NTSB investigations: Cessna 180, NY
19 cases on aircraft the registry lists as Cessna 180. 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 | 3 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 5 |
| 1968 | 1 |
| 1969 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1979 | 1 |
| 1983 | 1 |
| 2010 | 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 ('2072602'))
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 ('2072602'))
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 ERA10CA472Accident · Minor injuriesData collectionFinal reportCessna 180 · Huron, NYThe pilot's inadequate preflight planning and preparation, which resulted in a total loss of engine power due to fuel exhaustion.NTSB NYC83LA167Accident · No injuriesLimited investigationFinal reportCessna 180 · Duanesburg, NYThe plt landed the tailwheel equipped acft in a 15 kt, left x-wind. During the landing, the acft veered to the left into a rough area, ground looped & came to rest in a ditch. The plt stated that the right brake failed.NTSB NYC79FFJ12Accident · No injuriesClosedCessna 180 · Seneca Falls, NYNTSB NYC75DFA06Accident · No injuriesClosedCessna 180 · Glens Falls, NYNTSB NYC74FFJ21Accident · Serious injuriesClosedCessna 180 · Niagara Falls, NYNTSB NYC74FFJ13Accident · No injuriesClosedCessna 180 · Franklinville, NYNTSB NYC73DFJ04Accident · No injuriesClosedCessna 180 · Akron, NYNTSB NYC70F0142Accident · Minor injuriesClosedCessna 180 · Walkill, NYNTSB NYC69F0092Accident · No injuriesClosedCessna 180 · Millbrook, NYNTSB NYC68F0301Accident · No injuriesClosedCessna 180 · Spring Valley, NYNTSB NYC68D0192Accident · No injuriesClosedCessna 180 · New City, NYNTSB UNK67X0137Incident · 1 fatalClosedCessna 180 · Stormville, NYNTSB UNK67X0127Incident · 1 fatalClosedCessna 180 · Stormville, NYNTSB NYC67D0492Accident · No injuriesClosedCessna 180 · Richland, NYNTSB NYC67F0268Accident · No injuriesClosedCessna 180A · Stormville, NYNTSB NYC66F0385Accident · No injuriesClosedCessna 180 · North Creek, NYNTSB UNK64X3789Accident · No injuriesClosedCessna 180 · Stormville, NYNTSB UNK64X3153Accident · No injuriesClosedCessna 180 · Ronkonkoma Li, NYNTSB UNK64X1788Accident · No injuriesClosedCessna 180 · Endicott, NY