NTSB investigations, MO
14 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2009 | 1 |
|---|---|
| 2014 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2023 | 2 |
| 2025 | 1 |
| 2026 | 4 |
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\" = 'MO' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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" = 'MO' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN26FA311Accident · 2 fatalClass 3 · FieldPreliminary reportEXP Stol CH701 · Neosho, MOOn September 7, 2026, about 1337 central daylight time, an experimental STOL CH701 airplane, N101XV, sustained substantial damage when it was involved in an accident near Neosho, Missouri. The pilot and passenger sustained fatal injuries. The airplane was…NTSB CEN26LA290Accident · No injuriesClass 3 · LimitedPreliminary reportGulfstream Aerospace G-IV · St. Louis, MOOn August 14, 2026, about 1459 central daylight time, a Gulfstream Aerospace G-IV airplane, N406JS, was substantially damaged when it was involved in an accident near St. Louis, Missouri. The three crew members and 7 passengers were not injured. The airplane…NTSB ANC26FA054Accident · 1 fatalClass 3 · FieldPreliminary reportAir Tractor AT-502B · Forbes, MOOn June 15, 2026, about 2015 Central daylight time, an Air Tractor AT-502B airplane, N503GK, sustained substantial damage when it was involved in an accident near Forbes, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN26FA140Accident · 1 fatalClass 3 · FieldPreliminary reportAero Commander 500-B · Chesterfield, MOOn March 17, 2026, about 0024 central daylight time, an Aero Commander 500-B airplane, N444CA, was destroyed when it was involved in an accident near Chesterfield, Missouri. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN25FA346Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 340 · Kearney, MOOn August 27, 2025, about 1158 central daylight time, a Cessna 340A, N888MT, was substantially damaged when it was involved in an accident near Kearney, Missouri. The pilot and passenger were fatally injured. The airplane operated as a Title 14 Code of…NTSB CEN24LA039Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Ozark, MOA reported total loss of engine power for undetermined reasons.NTSB CEN23LA221Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Doniphan, MOA partial loss of engine power for undetermined reasons.NTSB CEN21FA380Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Adrian, MOThe pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and impact with terrain.NTSB CEN21LA307Accident · Serious injuriesClass 4 · LimitedFinal reportQuad City Challenger · Ste. Genevieve, MOAn impact with terrain for reasons that could not be determined based on available evidence.NTSB CEN20LA107Accident · No injuriesClass 3 · LimitedFinal reportZenith CH601 · Cabool, MOThe loss of engine power due to failure of the No. 1 cylinder piston for reasons that could not be determined based on available evidence.NTSB CEN19LA127Accident · No injuriesClass 3 · LimitedFinal reportBeech 50 · Sheldon, MOA partial loss of engine power on both engines due to detonation for undetermined reasons.NTSB CEN16LA229Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Humansville, MOA partial loss of engine power for reasons that could not determined, because an examination and test run of the engine did not reveal any anomalies that would have contributed to the loss of engine power.NTSB CEN15CA065Accident · Serious injuriesData collectionFinal reportHughes Aero Predator · Branson, MOThe pilot's failure to maintain aircraft control when executing a landing with a tailwind, resulting in impact with a retaining wall.NTSB CEN09LA573Accident · No injuriesLimited investigationFinal reportBeech B36TC · Sullivan, MOA loss of aircraft control for undetermined reasons.