NTSB investigations: Cessna 172E, NY
15 cases on aircraft the registry lists as Cessna 172E. 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 | 2 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1971 | 2 |
| 1972 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 2003 | 1 |
| 2004 | 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\" = 'NY' 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 ('2072412'))
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" = 'NY' 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 ('2072412'))
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 NYC04CA068Accident · No injuriesData collectionFinal reportCessna 172E · Batavia, NYThe pilot's failure to maintain directional control while landing. Factors were a tailwind and icy runway.NTSB NYC04LA046Accident · No injuriesLimited investigationFinal reportCessna 172E · Islip, NYThe pilot's failure to maintain aircraft control, which resulted in a nose over. A factor in this accident was the gusty wind conditions.NTSB NYC86LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Durhamville, NYThe flight was returning from a 4-LEG 300-mile cross country trip. On flare touchdown, the pilot reported severe vibration. As brakes were applied the vibration increased, and the aircraft became uncontrollable. The aircraft pulled to the right and collided…NTSB NYC86LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · East Moriches, NYThe acft was substantially damaged when it collided with trees during a forced landing following a loss of pwr during a takeoff climb. The plt reported that the pwr loss resulted from carb ice.NTSB NYC79FFA06Accident · No injuriesClosedCessna 172 · Albany, NYNTSB NYC76FFA47Accident · Serious injuriesClosedCessna 172E · Poestenkill, NYNTSB NYC73FFA01Accident · No injuriesClosedCessna 172E · Deposit, NYNTSB NYC72AN023Accident · 1 fatalClosedCessna 172E · Greene, NYNTSB NYC71FHJ25Accident · No injuriesClosedCessna 172 · Mahopac, NYNTSB NYC69D0116Accident · No injuriesClosedCessna 172 · Cicero, NYNTSB NYC68F0401Accident · No injuriesClosedCessna 172E · Rochester, NYNTSB NYC67D0465Accident · No injuriesClosedCessna 172 · Middletown, NYNTSB NYC66A0054Accident · No injuriesClosedCessna 172 · Jamaica, NYNTSB UNK65X0573Accident · 2 fatalClosedCessna 172B · Mattituck, NYNTSB UNK64X2566Accident · Minor injuriesClosedCessna 172 · Roscoe, NY