NTSB investigations: Cessna T182T

57 cases on aircraft the registry lists as Cessna T182T. 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, newest first

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072738', '2072739')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072738', '2072739'))
  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 ('2072738', '2072739'))
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 CHI04CA251Accident · No injuriesData collectionFinal reportCessna 182T · Lake In The Hil, ILthe excessive descent rate resulting in a hard landing.Sep 9, 2004 · N379BF · Substantial damage NTSB LAX04LA211Accident · No injuriesLimited investigationFinal reportCessna T182T · Paulden, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed.May 15, 2004 · N5341G · Substantial damage NTSB LAX03LA030Accident · No injuriesLimited investigationFinal reportCessna 182T · Scottsdale, AZThe pilot's failure to apply adequate crosswind compensation, which resulted in a loss of directional control. Factors were the crosswind and the pilot's lack of experience in the make and model of airplane.Nov 11, 2002 · N794SA · Substantial damage NTSB LAX03LA020Accident · No injuriesLimited investigationFinal reportCessna T182T · Long Beach, CAThe student's failure to maintain directional control and the instructor's inadequate supervision of the flight by his delayed remedial action.Nov 2, 2002 · N184TA · Substantial damage NTSB MKC77DCJ30Accident · No injuriesClosedCessna 305A · Scottsbluff, NEJul 17, 1977 · N1FR · Substantial damage NTSB MKC71DCJ13Accident · No injuriesClosedCessna 188A · Oxford, NEJul 30, 1970 · N3538Q · Substantial damage NTSB NYC67F0258Accident · No injuriesClosedCessna 172 · Plainville, CTSep 19, 1966 · N5190A · Substantial damage