NTSB investigations: Cessna 172H, NY
18 cases on aircraft the registry lists as Cessna 172H. 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
| 1967 | 1 |
|---|---|
| 1968 | 2 |
| 1970 | 2 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1976 | 2 |
| 1977 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1987 | 1 |
| 1995 | 1 |
| 2008 | 1 |
| 2011 | 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 ('2072424'))
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 ('2072424'))
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 ERA11CA144Accident · No injuriesData collectionFinal reportCessna 172H · Plattsburgh, NYThe student pilot's loss of directional control during the landing flare in gusting wind conditions and the certified flight instructor's delayed remedial action.NTSB NYC08LA199Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Brockport, NYA total loss of engine power due to fuel exhaustion as a result of the flight instructor's inadequate preflight planning.NTSB NYC96LA006Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Honeoye Falls, NYthe pilot's failure to establish a climb in that he failed to raise the flaps and failed to assure full power was applied during the go-around.NTSB NYC88LA003Accident · No injuriesLimited investigationFinal reportCessna 172H · Oneonta, NYThe plt rprtd he started to depart from rwy 13 with the wind from the south at 15 gusting 25 KTS. He stated the acft was not climbing as expected so he elected to land on the remaining rwy. He stated the wind gusts were strong from the right rear. He said he…NTSB NYC80FFA18Accident · Serious injuriesClosedCessna 172 · Highland Falls, NYNTSB NYC79FFA09Accident · Serious injuriesClosedCessna 172H · Malone, NYNTSB NYC77DFA34Accident · No injuriesClosedCessna 172 · Watertown, NYNTSB NYC77FGM03Accident · No injuriesClosedCessna 172 · West Hickory, NYNTSB NYC76FHM29Accident · No injuriesClosedCessna 172H · Mahopac, NYNTSB NYC74DFA24Accident · No injuriesClosedCessna 172 · Ellenville, NYNTSB NYC74FHM16Accident · No injuriesClosedCessna 172H · Newburgh, NYNTSB NYC73DFA27Accident · No injuriesClosedCessna 172H · Scotia, NYNTSB NYC71FFJ23Accident · No injuriesClosedBeech V35A · Endicott, NYNTSB NYC70DFJ09Accident · No injuriesClosedCessna 172H · Hilton, NYNTSB NYC70FFJ05Accident · Minor injuriesClosedCessna 172 · Buffalo, NYNTSB NYC68D0404Accident · No injuriesClosedCessna 172H · Mattituck, NYNTSB NYC68F0340Accident · No injuriesClosedCessna 172H · Deer Park, NYNTSB NYC67F0551Accident · No injuriesClosedCessna 172H · Remsen, NY