NTSB investigations, 2004, IN
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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
| 1963 | 1 |
|---|---|
| 1964 | 107 |
| 1965 | 116 |
| 1966 | 119 |
| 1967 | 132 |
| 1968 | 106 |
| 1969 | 88 |
| 1970 | 83 |
| 1971 | 81 |
| 1972 | 88 |
| 1973 | 77 |
| 1974 | 66 |
| 1975 | 86 |
| 1976 | 78 |
| 1977 | 90 |
| 1978 | 95 |
| 1979 | 70 |
| 1980 | 76 |
| 1981 | 52 |
| 1982 | 55 |
| 1983 | 54 |
| 1984 | 55 |
| 1985 | 54 |
| 1986 | 58 |
| 1987 | 53 |
| 1988 | 66 |
| 1989 | 45 |
| 1990 | 42 |
| 1991 | 33 |
| 1992 | 29 |
| 1993 | 35 |
| 1994 | 38 |
| 1995 | 33 |
| 1996 | 31 |
| 1997 | 36 |
| 1998 | 35 |
| 1999 | 22 |
| 2000 | 34 |
| 2001 | 29 |
| 2002 | 25 |
| 2003 | 20 |
| 2004 | 26 |
| 2005 | 20 |
| 2006 | 28 |
| 2007 | 23 |
| 2008 | 22 |
| 2009 | 30 |
| 2010 | 27 |
| 2011 | 26 |
| 2012 | 26 |
| 2013 | 22 |
| 2014 | 16 |
| 2015 | 19 |
| 2016 | 23 |
| 2017 | 22 |
| 2018 | 19 |
| 2019 | 22 |
| 2020 | 17 |
| 2021 | 21 |
| 2022 | 21 |
| 2023 | 16 |
| 2024 | 17 |
| 2025 | 13 |
| 2026 | 9 |
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\") = 2004
AND c.\"eventStateOrRegion\" = 'IN' 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") = 2004 AND c."eventStateOrRegion" = 'IN' 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 CHI05LA045Accident · No injuriesLimited investigationFinal reportPilatus PC-12/45 · South Bend, INFailure of the fuel control unit (FCU) bellows which resulted in a significant loss of engine power and the pilot's encounter with unsuitable terrain during the subsequent forced landing. A contributing factor was the pilot's inadvertent exceedence of the…NTSB CHI05CA035Accident · No injuriesData collectionFinal reportCessna 172S · Anderson, INThe student pilot's improper flare and his inadequate recovery from a bounced landing.NTSB CHI04LA279Accident · Serious injuriesLimited investigationFinal reportErnst Pitts S2E · Hanover, INThe pilot's failure to maintain clearance to the trees and terrain during the aerobatic maneuver. Contributing factors were the pilot's decision to perform a low-level, ostentatious aerobatic display and the trees.NTSB CHI04LA262Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Knox, INA loss of engine power for undetermined reasons. Contributing to the accident were the unsuitable terrain encountered, the dark night conditions, and the ditch.NTSB CHI04LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · Gary, INThe failure of the nose wheel for undetermined reasons. A factor associated with the accident was the student pilot's failure to properly flare the airplane.NTSB CHI04CA246Accident · Minor injuriesData collectionFinal reportUtterback Mustang II · Kendallville, INThe pilot's improper recovery from a bounced landing and his failure to maintain aircraft control.NTSB CHI04LA245Accident · Serious injuriesLimited investigationFinal reportFall Cub · Rockville, INThe fuel starvation encountered due to the builder's inadequate fuel system design and the subsequent loss of engine power during a maneuver for the landing approach. Factors were the tree and corn.NTSB CHI04LA227Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Anderson, INThe in-flight loss of engine power during downwind for undetermined reasons. A factor was the tree the airplane impacted during the forced landing.NTSB CHI04CA228Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Elkhart, INThe failure of the seat during landing roll and the subsequent pilot's airplane handling not being possible.NTSB CHI04CA229Accident · No injuriesData collectionFinal reportBell 47G2 · Muncie, INThe engine failure for an undetermined reason, and the pilot's inability to properly level-off for landing due to the low rotor speed, which resulted in the hard landing. The low altitude where the engine failure occurred was a factor.NTSB CHI04CA226Accident · No injuriesData collectionFinal reportDevereux Mustang II · Elkhart, INThe pilot not maintaining directional control during landing roll. A factor was the soft terrain, and the inadequate training in type aircraft.NTSB CHI04CA222Accident · No injuriesData collectionFinal reportMooney M20J · Huntington, INThe pilot's inadequate flare and unsuccessful recovery from a bounced landing, and the pilot's and flight instructor's failure to maintain directional control and airspeed during the subsequent aborted landing, which resulted in a stall. A factor was the…NTSB CHI04CA221Accident · No injuriesData collectionFinal reportCessna 310Q · Nappanee, INThe delay in the pilot's performance of an aborted takeoff. A factor was the reported restricted movement of the elevator. Additional factors were the rising easement and roadway the airplane went over before coming to rest in the farmers field.NTSB CHI04LA207Accident · No injuriesLimited investigationFinal reportSkystar Kitfox · Westfield, INthe failure of the pilot to maintain adequate airspeed resulting in a stall.NTSB CHI04LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Rockville, INThe restriction of airflow in the carburetor due to a foreign substance blockage of the venturi. A contributing factor was the trees.NTSB CHI04CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Noblesville, INThe pilot's failure to select carburetor heat and his failure to maintain airspeed resulting in a stall. Factors were unstabilized approach the aircraft's low altitude, and the weather conditions conducive to carburetor icing.NTSB CHI04CA172Accident · No injuriesData collectionFinal reportCessna 310P · Knox, INThe fatigue fracture of the main landing gear assembly.NTSB CHI04CA165Accident · No injuriesData collectionFinal reportCessna 172S · Fishers, INThe pilot's inadequate remedial actions after an inadequate landing flare and subsequent hard landing. Additional causes were the pilot-induced porpoise and the collapse of the nose landing gear.NTSB CHI04FA107Accident · 1 fatalField investigationFinal reportBell 206L-1 · Boonville, INThe pilot's inadequate planning/decision which resulted in his failure to maintain terrain clearance. Contributing factors were the pilot's inadequate preflight planning, his diverted attention, and the dark night conditions.NTSB CHI04LA103Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Marion, INThe pilot's inadequate preflight planning/decision to ensure adequate takeoff performance by the improper use of flaps and failure to establish the aircraft was within weight and balance limitations.NTSB CHI04CA102Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Lake Village, INThe unsuitable terrain the Certified Flight Instructor encountered during the off-field landing. The low altitude, the downdraft or "sink" experienced during flight, and the soft terrain conditions were factors to the accident.NTSB CHI04LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Bourbon, INThe inadequate annual inspection in that the worn brake disks were not replaced which resulted in diminished braking capability during the landing roll. A factor associated with the accident was the utility pole that the airplane contacted.NTSB CHI04LA078Accident · No injuriesLimited investigationFinal reportCessna R182 · Elberfeld, INThe in-flight and on-ground fires in the cabin and engine compartment for undetermined reasons during the flight's cruise and emergency landing.NTSB CHI04LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Jeffersonville, INThe pilot selecting a closed runway for landing and the collapse of the nose landing gear. Factors were the pilot's failure to obtain NOTAM information and the snowbank across the closed runway.NTSB CHI04LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Corydon, INThe student pilot become lost during the cross country flight and the instructor's inadequate supervision of both the flight and preflight planning. This led to the in-flight loss of engine power due to fuel exhaustion, a forced landing, and impact with…NTSB CHI04LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Fishers, INThe pilot not maintaining altitude/clearance from the trees during the circling approach, his continued descent below minimum descent altitude, and the pilot not performing a missed approach. A factor was the trees the pilot impacted during the circling…