NTSB investigations, 2019, MO
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1964 | 118 |
| 1965 | 136 |
| 1966 | 155 |
| 1967 | 173 |
| 1968 | 100 |
| 1969 | 83 |
| 1970 | 111 |
| 1971 | 112 |
| 1972 | 80 |
| 1973 | 80 |
| 1974 | 80 |
| 1975 | 98 |
| 1976 | 101 |
| 1977 | 96 |
| 1978 | 111 |
| 1979 | 100 |
| 1980 | 85 |
| 1981 | 95 |
| 1982 | 86 |
| 1983 | 84 |
| 1984 | 74 |
| 1985 | 72 |
| 1986 | 54 |
| 1987 | 59 |
| 1988 | 67 |
| 1989 | 47 |
| 1990 | 41 |
| 1991 | 37 |
| 1992 | 40 |
| 1993 | 58 |
| 1994 | 47 |
| 1995 | 39 |
| 1996 | 28 |
| 1997 | 33 |
| 1998 | 29 |
| 1999 | 43 |
| 2000 | 31 |
| 2001 | 33 |
| 2002 | 30 |
| 2003 | 30 |
| 2004 | 32 |
| 2005 | 31 |
| 2006 | 27 |
| 2007 | 31 |
| 2008 | 31 |
| 2009 | 23 |
| 2010 | 23 |
| 2011 | 32 |
| 2012 | 33 |
| 2013 | 21 |
| 2014 | 19 |
| 2015 | 31 |
| 2016 | 29 |
| 2017 | 28 |
| 2018 | 22 |
| 2019 | 20 |
| 2020 | 24 |
| 2021 | 15 |
| 2022 | 19 |
| 2023 | 25 |
| 2024 | 22 |
| 2025 | 19 |
| 2026 | 20 |
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 year(c.\"eventDate\") = 2019
AND c.\"eventStateOrRegion\" = 'MO' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2019 AND c."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA' 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 DCA20CA050Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · Kansas City, MOa bird strike during descentNTSB 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 GAA20CA072Accident · No injuriesData collectionFinal reportCessna U206 · Mexico, MOThe pilot's failure to properly set the parking brake before exiting an operating airplane, which resulted in a runaway airplane and subsequent impact with trees.NTSB CEN20FA003Accident · 1 fatalClass 3 · FieldFinal reportLancair Legacy · Bixby, MOThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB CEN19TA333Accident · No injuriesClass 3Final reportLancair Lancair 320 · Bolivar, MOInadequate maintenance of the airplane, which resulted in a lack of adequate hydraulic fluid, malfunction of the landing gear extension system, and the landing gear collapse on landing.NTSB GAA19CA549Accident · No injuriesData collectionFinal reportCessna L19 · Kennett, MOThe pilot's failure to install the engine oil filler cap before the first flight of the day; his subsequent failure to conduct a preflight check before the accident flight, which resulted in his failure to note that the cap was not installed; and his improper…NTSB CEN19LA319Accident · Minor injuriesClass 3 · LimitedFinal reportLancair LC41-550FG · Branson, MOA total loss of engine power after takeoff for undetermined reasons.NTSB GAA19CA451Accident · No injuriesData collectionFinal reportCessna 402 · St. Louis, MOThe airplane’s collision with a bird during short final.NTSB CEN19LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305A · Houston, MOA total loss of engine power during initial climb due to carburetor icing, which resulted in a forced landing and impact with trees and terrain.NTSB GAA19CA443Accident · No injuriesData collectionFinal reportValldejuli John A Aerocomp · Jefferson City, MOThe pilot's failure to maintain directional control during a touch-and-go landing in gusting crosswind conditions, which resulted in a runway excursion, impact with runway lights, and a nose-over.NTSB GAA19CA406Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, MOThe pilot's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall and a subsequent hard landing.NTSB CEN19LA198Accident · No injuriesClass 3 · LimitedFinal reportVans RV8 · Joplin, MOThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB CEN19FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 425 · Butler, MOThe pilot’s loss of airplane control during a descent to a diversion airport with only the left engine operating. Contributing to the accident was a malfunction of the right engine throttle, the cause of which could not be determined.NTSB GAA19CA476Accident · No injuriesData collectionFinal reportRobinson R44 · Lebanon, MOThe pilot's loss of yaw control and failure to maintain a proper descent rate and his subsequent improper use of the collective instead of the antitorque pedals to correct the yaw, which resulted in a hard landing.NTSB GAA19CA331Accident · Minor injuriesData collectionFinal reportCessna 150 · Lee's Summit, MOThe student pilot’s exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA19CA353Accident · No injuriesData collectionFinal reportCessna 177 · Festus, MOThe pilot's improper landing flare and failure to maintain pitch control with a crosswind, which resulted in a hard landing and a tail strike.NTSB GAA19CA231Accident · No injuriesData collectionFinal reportBeech 76 · St Charles, MOThe pilot receiving instruction's failure to extend the landing gear. Contributing to the accident were the pilot receiving instruction's failure to complete the landing checklist and the flight instructor's inadequate monitoring of the pilot.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 GAA19CA170Accident · No injuriesData collectionFinal reportPiper PA 11 · Moberly, MOThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions.NTSB CEN19FA093Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Summersville, MOThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight fuel planning and in-flight fuel monitoring.