NTSB investigations: Cessna 172I, NY
13 cases on aircraft the registry lists as Cessna 172I. 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
| 1968 | 2 |
|---|---|
| 1969 | 2 |
| 1971 | 3 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1978 | 1 |
| 1984 | 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 ('2072426'))
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 ('2072426'))
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 NYC85FFA01Accident · Serious injuriesFinal reportCessna 172I · Essex, NYWitnesses stated acft became airborne near the slight rise in the rwy, aprx 1500 ft down the rwy, and climbed to aprx 60 ft AGL. Acft shuttered and nose of acft pitched up. Left wing and nose then dropped. Acft continued descending to the left across a small…NTSB NYC79FA007Accident · 2 fatalClosedCessna 172 · Marcy, NYNTSB NYC76DHJ04Accident · No injuriesClosedCessna 172 · Farmingdale, NYNTSB NYC76DFA40Accident · No injuriesClosedCessna 172 · Kingston, NYNTSB NYC74DFJ29Accident · No injuriesClosedCessna 172 · Cortland, NYNTSB NYC74FFA16Accident · No injuriesClosedCessna 172I · Alexandria Bay, NYNTSB NYC71FFJ36Accident · No injuriesClosedCessna 172 · Honeoye Falls, NYNTSB NYC71FHM28Accident · No injuriesClosedCessna 172 · Marlboro, NYNTSB NYC71DFA42Accident · No injuriesClosedCessna 172 · Canastota, NYNTSB NYC70F0204Accident · No injuriesClosedCessna 150 · Canastota, NYNTSB NYC70F0168Accident · Minor injuriesClosedCessna 172I · Little Valley, NYNTSB NYC69D0297Accident · No injuriesClosedCessna 172 · Roscoe, NYNTSB NYC69D0085Accident · No injuriesClosedCessna 172 · Dansville, NY