Final NTSB investigations: Cessna 172, ND
14 cases on aircraft the registry lists as Cessna 172. 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 | 1 |
|---|---|
| 1966 | 2 |
| 1967 | 2 |
| 1969 | 2 |
| 1971 | 1 |
| 1973 | 2 |
| 1975 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 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\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072402'))
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" = 'ND' AND c."eventCountry" = 'USA'
AND c."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072402'))
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 DEN85LA219Accident · No injuriesLimited investigationFinal reportCessna C-172 · Killdeer, NDThe plt said he measured the length of the r/w prior to t/o. the t/o was normal on a downsloping r/w with trees at the FAR end. The plt said that as the a/c lifted off the r/w the a/c struck the trees. He said a gust of wind caused the a/c to settle into the…NTSB DEN81FTG18Accident · No injuriesClosedCessna 172 · Bowdon, NDNTSB DEN81DTG05Accident · No injuriesClosedCessna 172 · Oakes, NDNTSB MKC76FTG07Accident · No injuriesClosedCessna 172 · Turtle Lake, NDNTSB MKC74DTG11Accident · No injuriesClosedCessna 172 · Bowman, NDNTSB MKC73DTG13Accident · No injuriesClosedCessna 172 · Grace City, NDNTSB MKC71DDD18Accident · No injuriesClosedCessna 172 · Watford Cty, NDNTSB MKC70D0282Accident · No injuriesClosedCessna 172 · Columbus, NDNTSB MKC70D0273Accident · No injuriesClosedCessna 172 · Carpio, NDNTSB MKC68F0232Accident · Minor injuriesClosedCessna 172 · Mercer, NDNTSB MKC68F0095Accident · No injuriesClosedCessna 172 · Devils Lake, NDNTSB MKC67F0128Accident · No injuriesClosedCessna 172 · Gilby, NDNTSB MKC67F0125Accident · No injuriesClosedCessna 172 · Rock Lake, NDNTSB MKC65F0044Accident · Minor injuriesClosedCessna 172 · Bartlett, ND