NTSB investigations, MO
8 cases where the sequence of events included Aircraft maintenance event.
Cases per year
| 2009 | 2 |
|---|---|
| 2010 | 1 |
| 2013 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2025 | 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\" = '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\" = '040' 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" = '040' 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 CEN25LA295Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182P · Bolivar, MOOn July 28, 2025, at about 1800 central daylight time, a Cessna 182P, N8243M, was destroyed when it was involved in an accident near Bolivar, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB CEN22LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-46-310P · Cassville, MOThe pilot’s failure to reinstall the nose landing gear linkage prior to the flight which resulted in a loss of directional control during landing.NTSB ERA20LA050Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac CH-650 · Willow Springs, MOImproper maintenance practices on the fuel system causing fuel starvation and a total loss of engine power.NTSB CEN17LA206Accident · No injuriesLimited investigationFinal reportKenneth B Hines Nieuport 28 · Boonville, MOA partial loss of engine power due to a compromised induction system.NTSB CEN13LA396Accident · No injuriesLimited investigationFinal reportBell 47D1 · Lake Ozark, MOThe improper rebuild and maintenance of the helicopter and inadequate subsequent inspections, which resulted in undetected fuel contamination and a subsequent total loss of engine power during cruise flight.NTSB CEN10LA171Accident · No injuriesLimited investigationFinal reportLoehr Thomas H Zenith Stol CH701 · Eldon, MOA loss of engine thrust during takeoff due to the failure of the engine-to-propeller drive belts as a result of improper belt tension. Contributing to the accident was the non-certificated pilot's improper preflight inspection.NTSB CEN09CA493Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Cape Girardeau, MOThe airplane's inoperative brakes while taxiing. Contributing to the accident was the pilot's inadequate preflight.NTSB CEN09LA335Accident · No injuriesLimited investigationFinal reportCessna 140 · St. Louis, MOThe improper installation of the wing fairing during recent maintenance, which resulted in the partial separation of the fairing shortly after takeoff.