NTSB investigations: Cessna A185F, NY
10 cases on aircraft the registry lists as Cessna A185F. 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
| 1975 | 1 |
|---|---|
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1982 | 1 |
| 2000 | 1 |
| 2007 | 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 ('2072821', '2070107'))
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 ('2072821', '2070107'))
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 ERA10LA389Accident · 1 fatalLimited investigationFinal reportCessna A185F · Newfane, NYThe pilot's failure to maintain aircraft control due to his diverted attention, which resulted in a collision with trees during the initial climb after takeoff. Contributing to the accident was the passenger's attempt to secure the jump door after it opened…NTSB ATL07LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Danube, NYThe pilot's mismanagement of the fuel supply.NTSB NYC00LA077Accident · No injuriesLimited investigationFinal reportCessna 185 · Saratoga Sprngs, NYThe pilot's loss of control of the airplane during the landing.NTSB NYC82DA232Accident · No injuriesFinal reportCessna 185F · Lake George, NYWitnesses to the accident described a nose up pitch attitude of between thirty and forty-five degrees during the initial climb after departing Lake George. At several hundred feet above the ground, the aircraft was observed to make a desending left turn to…NTSB NYC81FFA03Accident · No injuriesClosedCessna 185F · Round Lake, NYNTSB NYC80FFA02Accident · No injuriesClosedCessna 185 · Booneville, NYNTSB NYC80FHJ01Accident · Serious injuriesClosedCessna 185 · Westhampton, NYNTSB NYC77FHJ31Accident · No injuriesClosedCessna 185F · Saltaire, NYNTSB NYC77FHJ01Accident · No injuriesClosedCessna 185 · Port Washingtn, NYNTSB NYC7KFHJ33Incident · No injuriesClosedCessna 185 · Coram, NY