NTSB investigations: Cessna 140, MA
16 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 | 3 |
|---|---|
| 1965 | 2 |
| 1966 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1986 | 1 |
| 1992 | 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\" = 'MA' 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" = 'MA' 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 NYC92LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Palmer, MAThe improper use of carburetor heat which resulted in a power loss due to carburetor ice over unsuitable terrain. Factors related to the accident were the carburetor icing conditions and the failure of the pilot to be aware of the temperature/dewpoint spread.NTSB NYC86LA091Accident · No injuriesLimited investigationFinal reportCessna 140 · Newburyport, MAWhile taxiing on a grass taxiway, the acft contacted a soft spot in the grass and nosed over.NTSB NYC78FNE25Accident · Serious injuriesClosedCessna 140 · Oxford, MANTSB NYC76DNA44Accident · Minor injuriesClosedCessna 140 · Norfolk, MANTSB NYC76AN029Accident · No injuriesClosedCessna 150 · Fitchburg, MANTSB NYC71FFD39Accident · Minor injuriesClosedCessna 140 · Mrstns Mills, MANTSB NYC70DFD13Accident · No injuriesClosedCessna 140 · Marlboro, MANTSB NYC70D0159Accident · No injuriesClosedCessna 140 · Westboro, MANTSB NYC69D0449Accident · No injuriesClosedCessna 140 · Agawam, MANTSB NYC68F0470Accident · No injuriesClosedCessna 140 · Norwood, MANTSB NYC67F0017Accident · No injuriesClosedCessna 140 · Fitchburg, MANTSB NYC66D0414Accident · No injuriesClosedCessna 140 · Tewksbury, MANTSB UNK65X1216Accident · No injuriesClosedCessna 140 · Millbury, MANTSB UNK64X1258Accident · No injuriesClosedCessna 140A · Marlboro, MANTSB UNK64X1137Accident · Serious injuriesClosedCessna 140 · Plymouth, MANTSB UNK64X1026Accident · 1 fatalClosedCessna 140 · Westboro, MA