NTSB investigations: Cessna 182N
5 cases on aircraft the registry lists as Cessna 182N, where the first occurrence was “Overrun”. 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
| 1984 | 1 |
|---|---|
| 1987 | 1 |
| 1990 | 1 |
| 1998 | 1 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072730')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 340))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072730')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 340))
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 SEA04CA142Accident · No injuriesData collectionFinal reportCessna 182N · Bainville, MTThe pilot's misjudgment of his airspeed on landing, and his subsequent overrunning of the runway. A contributing factor was the trees.NTSB FTW98LA184Accident · No injuriesLimited investigationFinal reportCessna 182N · Albuquerque, NMThe pilot's failure to attain the proper touchdown point during landing, resulting in an overrun, and his exceeding the airplane's maximum crosswind component. A factor was the gusty crosswind.NTSB FTW90LA159Accident · No injuriesLimited investigationFinal reportCessna 182N · Justin, TXThe unexpected impairment of the pilot. Factors related to the accident were: the pilot's selection of a short grass runway with a tailwind, the high air temperature, and the obstructions (fence & power line) at the end of the runway.NTSB NYC87LA153Accident · No injuriesLimited investigationFinal reportCessna 182 · Ellington, CTThe pilot stated that while making a standard left traffic pattern, the wind at the north end of the airport shifted from the southeast to the northwest. The acft touched down with excessive ground speed, ran off the end of the rwy and came to rest on a…NTSB MKC84LA191Accident · No injuriesLimited investigationFinal reportCessna 182N · Beaver City, NEThe acft was landed on an uncontrolled arpt toward the nnw, & after touchdown, it did not slow down adequetely. According to the plt, he elected to ground loop the acft rather than to continue off the end of the rwy. During the attempted ground loop, the acft…