NTSB investigations: Cessna 182P, NC
9 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
| 1972 | 1 |
|---|---|
| 1973 | 1 |
| 1975 | 1 |
| 1981 | 1 |
| 1990 | 1 |
| 1998 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2013 | 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\" = 'NC' 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" = 'NC' 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 ERA13LA262Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Brevard, NCThe cylinder manufacturer's misalignment of the exhaust valve guides in the No. 2 cylinder during manufacture, which resulted in the exhaust valve sticking and the pushrod breaking and the subsequent total loss of engine power.NTSB MIA08CA151Accident · No injuriesData collectionFinal reportCessna 182P · Salisbury, NCThe student pilot's improper flare during landing.NTSB NYC08CA016Accident · No injuriesData collectionFinal reportCessna 182 · Hendersonville, NCThe pilot's failure to calculate weight and balance prior to departure, which resulted in departure above the maximum allowable gross weight, and the airplane's inability to climb. Contributing to the accident was the high density altitude.NTSB MIA98LA204Accident · No injuriesLimited investigationFinal reportCessna 182P · Concord, NCthe failure of the pilot to maintain directional control and his failure to maintain wingtip clearance with trees that border the right side of the runway.NTSB ATL90LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Sanford, NCThe failure of the no.1 piston, for undetermined reasons, which resulted in a complete loss of engine power. A factor to the accident was, the forced landing in a soft field.NTSB ATL81FA054Accident · 2 fatalClosedCessna 182P · Jefferson, NCNTSB IAD76FLJ02Accident · No injuriesClosedCessna 182P · Raeford, NCNTSB IAD74DKM16Accident · No injuriesClosedCessna 182 · Hickory, NCNTSB NYC73FCJ12Incident · No injuriesClosedCessna 182P · Morrisville, NC