NTSB investigations: Cessna 172, NE
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 |
|---|---|
| 1967 | 4 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1981 | 1 |
| 1993 | 1 |
| 1998 | 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\" = 'NE' 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 ('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" = 'NE' 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 ('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 CHI98FA165Accident · 2 fatalField investigationFinal reportCessna 172 · S. Sioux City, NEThe pilot's failure to maintain adequate flying airspeed during the climbing left turn resulting in a stall condition. Contributing factors were the gusty, crosswind conditions, and the pilot's excessively tight turn maneuver during the initial climb.NTSB CHI93LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Weeping Water, NEThe pilot's failure to abort the takeoff when the airplane first touched down on the clear area adjacent to the departure runway.NTSB MKC81DCJ21Accident · No injuriesClosedCessna 172 · Naper, NENTSB MKC74DCJ21Accident · No injuriesClosedCessna 172 · Omaha, NENTSB MKC72FCJ61Accident · No injuriesClosedCessna 172 · Greenwood, NENTSB MKC72DCJ07Accident · Serious injuriesClosedCessna 172 · Oneill, NENTSB MKC71DCJ55Accident · No injuriesClosedCessna 172 · Stromsburg, NENTSB MKC71FCJ01Accident · Minor injuriesClosedCessna 172 · Millard, NENTSB MKC69D0055Accident · No injuriesClosedCessna 172 · Exeter, NENTSB MKC68D0346Accident · No injuriesClosedCessna 172 · Blair, NENTSB MKC68D0345Accident · No injuriesClosedCessna 172 · Newport, NENTSB MKC68F0325Accident · 1 fatalClosedCessna 172 · Lexington, NENTSB MKC67F0603Accident · Minor injuriesClosedCessna 172 · Shelton, NENTSB MKC65D0100Accident · No injuriesClosedCessna 172 · Ogallala, NE