NTSB investigations: Cessna R182, NY
7 cases on aircraft the registry lists as Cessna R182. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1997 | 1 |
| 2003 | 2 |
| 2005 | 1 |
| 2014 | 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 ('2072734'))
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 ('2072734'))
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 ERA14LA390Accident · No injuriesLimited investigationFinal reportCessna R182 · Farmingdale, NYThe failure of the aluminum nipple fuel supply line fitting, which resulted in an engine compartment fire.NTSB NYC05CA102Accident · Minor injuriesData collectionFinal reportCessna R182 · Hancock, NYThe pilot's misjudgment of speed/distance which resulted in a runway overrun. A factor was the wet turf runway.NTSB NYC03LA093Accident · No injuriesLimited investigationFinal reportCessna R182 · Monticello, NYThe pilot's premature raising of the flaps during the aborted landing. A factor in this accident was the crosswind condition.NTSB NYC03LA050Accident · No injuriesLimited investigationFinal reportCessna 182R · Warwick, NYThe pilot's inadequate compensation for winds, and his failure to maintain the proper descent rate. A factor in the accident was the gusty wind conditions.NTSB IAD97LA082Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Poughkeepsie, NYThe pilot's delayed decision to abort the landing.NTSB NYC83LA084Accident · No injuriesLimited investigationFinal reportCessna 182 · Batavia, NYThe pilot had trouble with maintaining heading during the entire flight due to malfunction of the rudder trim. During landing, directional control was lost and the acft left the runway and collided with trees. An inspection of the rudder sys revealed…NTSB NYC82DA198Accident · No injuriesFinal reportCessna R182 · Endicott, NYAfter making an approach and go-around, the pilot turned to a downwind and moved the gear selector to the down position. However, the gear would not extend by using either the normal system or emergency hand pump. Subsequently, the aircraft was landed on a…