Skip to content

NTSB investigations · 63

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2072701') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2072701')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2072701')
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 CHI00LA304Accident · No injuriesLimited investigationFinal reportCessna 182S · Wichita, KSthe pilot's failure to maintain aircraft control during the landing. Factors relating to this accident were the pilot's improper recovery from the bounced landing and his failure to go-around.Sep 22, 2000 · N97TD · Substantial damage NTSB CHI00LA292Accident · Minor injuriesLimited investigationFinal reportCessna 182S · Ellington, MOThe pilot's failure to maintain control of the aircraft during the aborted landing. Contributing to the accident was the rich mixture caused by an obstruction in the regulator section of the fuel servo.Sep 8, 2000 · N182KC · Substantial damage NTSB CHI00LA217Accident · No injuriesLimited investigationFinal reportCessna 182S · Millard, NEthe improper recovery from the bounced landing and the porpoise encountered by the pilot. Factors were the misjudged flare by the pilot and the runway light.Jul 22, 2000 · N7278S · Substantial damage NTSB NYC00LA188Accident · No injuriesLimited investigationFinal reportCessna 182S · White Plains, NYThe student pilot's failure to recover from a bounced landing and her failure to perform a go-around.Jul 8, 2000 · N729AD · Substantial damage NTSB SEA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182S · Kennewick, WAThe pilot's decision to continue flight into known icing conditions, and his subsequent failure to maintain adequate airspeed on final approach, resulting in a hard landing. Factors included: icing conditions; the pilot's improper decision to continue to his…Dec 30, 1999 · N374TC · Substantial damage NTSB IAD00LA001Accident · No injuriesLimited investigationFinal reportCessna 182S · Staatsburg, NYwas the pilot's encounter with an unseen embankment while maneuvering to avoid a deer on the runway.Oct 16, 1999 · N783WW · Substantial damage NTSB SEA99LA167Accident · No injuriesLimited investigationFinal reportCessna 182S · Kamiah, IDThe pilot's excessive airspeed on final approach, his inadequate remedial action, and his failure to attain the proper touchdown point during landing. Factors included a short, confined landing area and a tailwind.Sep 18, 1999 · N182MA · Substantial damage NTSB ATL85FA101Accident · 2 fatalField investigationFinal reportCessna 182R · Burkes Garden, VAThe plt departed manassas without a current wx briefing or filing a flt plan. Plt had also left maps and a list of checkpoints at home. His route of flt was into an area of low ceilings and visibility. The acft crashed into a mountain at the 3850 ft level.…Feb 19, 1985 · N2370E · Destroyed NTSB DEN80FQA07Accident · No injuriesClosedCessna 182 · Dexter, NMNov 4, 1979 · N2462X · Substantial damage NTSB FTW76O0009Accident · No injuriesClosedCessna 320 · Ciudad, MexicoSep 2, 1976 · N4196T · Destroyed NTSB FTW74FQG37Accident · No injuriesClosedCessna 340 · Midland, TXJan 10, 1974 · N9887F · Substantial damage NTSB LAX72FVA77Accident · Serious injuriesClosedCessna 182G · Arvin, CAJun 3, 1972 · N3775U · Substantial damage NTSB NYC71DFA08Accident · Serious injuriesClosedCessna 140 · Ticonderoga, NYAug 2, 1970 · N72613 · Substantial damage

Back to Cessna 182S