NTSB investigations: Cessna 182P, PA
14 cases on aircraft the registry lists as Cessna 182P. 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
| 1973 | 1 |
|---|---|
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2020 | 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\" = 'PA' 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 ('2075816'))
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" = 'PA' 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 ('2075816'))
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 ERA21LA094Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Stowe, PAThe pilot's loss of directional control while landing in a gusty crosswind, which resulted in a runway excursion and subsequent impact with terrain.NTSB IAD04CA012Accident · No injuriesData collectionFinal reportCessna 182P · Titusville, PAThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the snow bank.NTSB NYC02LA033Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Brookville, PAFouling of the engine intake and exhaust valves with bromine and lead deposits.NTSB NYC99LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Dorrance, PAThe pilot's misjudgment of distance and altitude, and his failure to do a go-around.NTSB NYC90LA211Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Peters Twp, PAThe pilot in commands failure to maintain airspeed on final approach resulting in an inadvertent stall and hard landing.NTSB NYC87LA162Accident · No injuriesLimited investigationFinal reportCessna 182 · Vera Cruz, PAThe plt rprtd that while en route at 3500 ft, the eng began to vibrate. About 1 min later, oil started covering the windshield & the cockpit began filling with smoke. He shut down the eng & looked for a place to land. Before landing, he restarted the eng, but…NTSB NYC84LA318Accident · No injuriesLimited investigationFinal reportCessna 182P · West Mifflin, PAOn arrival at airport, plt received wind information from twr as varying from 230 to 250 degrees at 15 KTS gusting to 20 and was offerred a choice of rwy 28 or rwy 23. Rwy 23 is 100 ft wide and 2380 ft long. Plt chose rwy 28. At landing flare, acft…NTSB NYC83LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Thomasville, PAThe acft nosed over during a forced landing after a power loss. Several weeks prior to this accident the acft made a precautionary landing due to a rough running engine. The acft was examined and 1 gallon of water was found in the fuel lines. The water was…NTSB NYC79DHA28Accident · No injuriesClosedCessna 182P · Moscow, PANTSB NYC79FGT03Accident · Minor injuriesClosedCessna 182 · New Oxford, PANTSB NYC76AN094Accident · 3 fatalClosedCessna 182 · Hilltown, PANTSB NYC75DGT11Accident · No injuriesClosedCessna 182 · Morris, PANTSB NYC74FGT14Accident · No injuriesClosedCessna 182 · New Cumberland, PANTSB NYC73FHA22Accident · No injuriesClosedCessna 182 · Skytop, PA