NTSB investigations: Cessna 140, CO
23 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 | 6 |
|---|---|
| 1965 | 1 |
| 1966 | 3 |
| 1967 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1976 | 3 |
| 1977 | 1 |
| 1984 | 1 |
| 2013 | 1 |
| 2018 | 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\" = 'CO' 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" = 'CO' 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 GAA19CA026Accident · No injuriesData collectionFinal reportCessna 140 · Denver, COThe pilot’s inadvertent brake application, which resulted in a loss of directional control and a subsequent nose-over.NTSB CEN13CA266Accident · No injuriesData collectionFinal reportCessna 140 · Glenwood Springs, COThe pilot's failure to maintain airplane control during the landing roll and his excessive use of right brake, which resulted in a noseover.NTSB DEN84LA129Accident · No injuriesLimited investigationFinal reportCessna 140 · Aurora, COAccording to the plt, the acft suddenly ground looped during the landing & departed the rwy. An investigation revealed that the left gear leg had collapsed at some time during the accident sequence. The left gear leg pin, which was found sheared, had a dark…NTSB DEN77DTE72Accident · No injuriesClosedCessna 140 · Platner, CONTSB DEN76FTE81Accident · Serious injuriesClosedCessna 140 · Englewood, CONTSB DEN76FTE67Accident · No injuriesClosedCessna 140 · Byers, CONTSB DEN76FTE60Accident · No injuriesClosedCessna 140 · Peyton, CONTSB DEN75AD012Accident · 1 fatalClosedCessna 140 · Virginia Dle, CONTSB DEN74DTE51Accident · No injuriesClosedCessna 140 · Otis, CONTSB DEN74AD013Accident · 1 fatalClosedCessna 140 · Divide, CONTSB DEN72DTE13Accident · No injuriesClosedCessna 140 · Loveland, CONTSB DEN69D0203Accident · No injuriesClosedCessna 140 · Littleton, CONTSB DEN67D0228Accident · No injuriesClosedCessna 140 · Glenwood Spg, CONTSB DEN67D0164Accident · No injuriesClosedCessna 140 · Aurora, CONTSB DEN67F0176Accident · 1 fatalClosedCessna 140 · Broomfield, CONTSB DEN66D0311Accident · No injuriesClosedCessna 140 · Watkins, CONTSB DEN66F0094Accident · No injuriesClosedCessna 140 · Aurora, CONTSB UNK65X0835Accident · No injuriesClosedCessna 140 · Longmont, CONTSB UNK64X3686Accident · No injuriesClosedCessna 140 · Greely, CONTSB UNK64X3363AccidentClosedCessna 140 · Sterling, CONTSB UNK64X3298Accident · No injuriesClosedCessna 140 · Denver, CONTSB UNK64X1616Accident · No injuriesClosedCessna 140 · Boulder, CONTSB UNK64X0105Accident · No injuriesClosedCessna 140 · Littleton, CO