NTSB investigations: Cessna 140, NH
14 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
| 1965 | 3 |
|---|---|
| 1967 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 2 |
| 1977 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 2014 | 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\" = 'NH' 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" = 'NH' 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 ERA14CA195Accident · No injuriesData collectionFinal reportCessna 140 · Colebrook, NHThe pilot's decision to power out of soft snow with a gusty quartering tailwind which resulted in the tail of the airplane rising and the airplane nosing over.NTSB NYC83LA233Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Windham, NHThe eng quit during takeoff & the acft crashed into trees. The plt admitted having used 87 octane automotive no-lead gasoline in the acft.NTSB NYC81FNC09Accident · No injuriesClosedCessna 140 · Enfield, NHNTSB NYC78DNC07Accident · No injuriesClosedCessna 140 · Jaffey, NHNTSB NYC75FNC09Accident · No injuriesClosedCessna 140 · Nashua, NHNTSB NYC74DNC38Accident · No injuriesClosedCessna 140 · Wolfeboro, NHNTSB NYC74DNC29Accident · No injuriesClosedCessna 140 · Gilmanton, NHNTSB NYC73FNC50Accident · No injuriesClosedCessna 140 · Manchester, NHNTSB NYC72DNC51Accident · Serious injuriesClosedCessna 140 · Rochester, NHNTSB NYC71DFG10Accident · No injuriesClosedCessna 140 · Pelham, NHNTSB NYC67D0538Accident · No injuriesClosedCessna 140 · Nashua, NHNTSB NYC65F0183Accident · No injuriesClosedCessna 140 · Rochester, NHNTSB NYC65F0045Accident · No injuriesClosedCessna 140 · Rochester, NHNTSB UNK65X1305Accident · Minor injuriesClosedPiper PA-22 · Nashua, NH