NTSB investigations: Cessna 182A, PA

10 cases on aircraft the registry lists as Cessna 182A. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

NTSB investigations: Cessna 182A, PA per year, 1965–2026: 10 cases
1965	1
1966	1
1967	1
1971	1
1972	2
1981	1
1997	1
1998	1
2020	1

Where

Open the map

Latest cases

Query with SQL

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 ('2072704')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('2072704'))
  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 ('2072704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA20LA258Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Pottstown, PAThe pilot's failure to ensure that sufficient fuel was onboard for nonlevel flight, which resulted in a total loss of engine power due to fuel starvation.Jul 21, 2020 · N4092D · Substantial damage NTSB IAD98LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fogelsville, PAThe pilot's failure to maintain control of the aircraft upon glider release. A contributing factor was the high vegetation (corn).Mar 7, 1998 · N9977B · Substantial damage NTSB NYC97LA140Accident · No injuriesLimited investigationFinal reportCessna 182A · Hayfield Twnshp, PAThe pilot's improper decision to attempt a takeoff from unsuitable terrain and failure to maintain airspeed. A factor in this accident was the gusty wind conditions.Jul 8, 1997 · N4951D · Destroyed NTSB NYC82FGT03Accident · No injuriesClosedCessna 182A · Chambersburg, PAOct 11, 1981 · N4724D · Substantial damage NTSB NYC73AN046Accident · 1 fatalClosedCessna 182A · Avoca, PAJul 31, 1972 · N3792D · Destroyed NTSB NYC72FGM38Accident · No injuriesClosedCessna 182 · Sharon, PAMar 29, 1972 · N4774D · Substantial damage NTSB NYC71FGM41Accident · Minor injuriesClosedCessna 182A · Johnstown, PAApr 16, 1971 · N6333B · Substantial damage NTSB NYC68F0288Accident · Minor injuriesClosedCessna 182 · Kimberton, PANov 18, 1967 · N5928B · Substantial damage NTSB NYC67F0206Accident · No injuriesClosedCessna 182A · Pottstown, PASep 3, 1966 · N2041G · Substantial damage NTSB NYC66F0205Accident · No injuriesClosedCessna 182A · Dravosburg, PAAug 23, 1965 · N4732D · Substantial damage