NTSB investigations: Cessna 140, AZ
32 cases on aircraft the registry lists as Cessna 140. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1964 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1967 | 4 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 1 |
| 1981 | 2 |
| 1982 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 1998 | 1 |
| 2006 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071602', '2071603'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071602', '2071603'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR25LA099Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Salome, AZThe total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection.NTSB WPR22LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Prescott, AZThe pilot receiving instructions failure to maintain directional during the takeoff ground roll and the flight instructor’s inadequate supervision.NTSB WPR21LA166Accident · 2 fatalClass 3 · LimitedFinal reportCessna 140 · Williams, AZThe pilot’s loss of control due to spatial disorientation shortly after takeoff in night visual meteorological conditions.NTSB GAA16CA152Accident · No injuriesData collectionFinal reportCessna 140 · Chandler, AZThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, a ground loop, and a collision with an airport sign.NTSB WPR15CA073Accident · Minor injuriesData collectionFinal reportCessna 140 · Yuma, AZThe pilot's failure to compensate for crosswind conditions during takeoff, which resulted in the loss of directional control and collision with terrain.NTSB WPR14CA090Accident · No injuriesData collectionFinal reportCessna 140 · Marana, AZThe pilot did not maintain directional control during the landing roll out when the right brake did not release completely after he applied, then released brake pressure, which resulted in a ground loop. Contributing to the accident was the taxi speed.NTSB WPR13CA097Accident · No injuriesData collectionFinal reportCessna 140 · Tucson, AZThe pilot’s failure to maintain directional control during the landing roll and his excessive application of brakes, which resulted in a noseover.NTSB LAX06CA127Accident · No injuriesData collectionFinal reportCessna 140 · Mesa, AZthe pilot's improper use of the flight controls during landing, which resulted in a nose over.NTSB LAX98LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Goodyear, AZThe inadvertent brake activation by the student pilot while practicing touch-and-go landings.NTSB LAX91LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZThat the pilot improperly used the flight controls and brakes. Contributing to this accident was an existing cross/tailwind.NTSB LAX86LA298Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZA Cessna 140 lost control on takeoff ground run from rwy 21 and collapsed the right main landing gear. On the takeoff roll the acft veered to the right and as the acft approached the end of the rwy 21, it veered sharply back to the left collapsing the right…NTSB LAX82DA205Accident · No injuriesFinal reportCessna 140 · Phoenix, AZA Mcdonnell Douglas DC-10 had landed and proceeded to the ramp area. As he entered the ramp and started toward gate 6, the green signal light changed to red and the pilot stopped with the DC-10'S tail pointed toward the parrallel taxiway beside runway 08R.…NTSB LAX82FUJ16Accident · Serious injuriesClosedCessna 140 · Cottonwood, AZNTSB LAX81FUJ75Accident · No injuriesClosedCessna 140 · Glendale, AZNTSB LAX79DUJ79Accident · No injuriesClosedCessna 140 · Poston, AZNTSB LAX79FUJ03Accident · No injuriesClosedCessna 140 · Mesa, AZNTSB LAX78DUJ91Accident · No injuriesClosedCessna 140 · Mesa, AZNTSB LAX78FA038Accident · 1 fatalClosedCessna 140 · Buckeye, AZNTSB LAX78FUJ06Accident · No injuriesClosedCessna 140 · Tonopah, AZNTSB LAX74DUJ29Accident · No injuriesClosedCessna 140 · Willcox, AZNTSB LAX72DUJ65Accident · No injuriesClosedCessna 140 · Phoenix, AZNTSB LAX71AL065Accident · 2 fatalClosedCessna 140 · Phoenix, AZNTSB LAX70DUJ32Accident · No injuriesClosedCessna 140 · Dnosaur Cty, AZNTSB LAX68F0080Accident · No injuriesClosedCessna 140 · Tucson, AZNTSB LAX68A0007Accident · 3 fatalClosedCessna 140 · Florence, AZNTSB LAX67F0412Accident · Minor injuriesClosedCessna 140 · Tucson, AZNTSB LAX67A0087Accident · 2 fatalClosedCessna 140 · Parker, AZNTSB LAX67D0051Accident · No injuriesClosedCessna 140 · Roll, AZNTSB DEN66D0158Accident · No injuriesClosedCessna 140 · Yuma, AZNTSB DEN66D0043Accident · No injuriesClosedCessna 140 · Hereford, AZNTSB UNK64X3488Accident · No injuriesClosedCessna 140 · Mesa, AZNTSB UNK64X1625Accident · 2 fatalClosedCessna 140 · Winslow, AZ