NTSB investigations, 2001, 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\") = 2001
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") = 2001 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 CHI02LA055Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Elkhart, INThe pilot allowed the airplane's altitude to get too low while on final approach. A factor associated with the accident was the pickup truck which the airplane struck.NTSB CHI02FA042Accident · 2 fatalField investigationFinal reportMooney M20M · Evansville, INThe fatigue failure of the turbocharger exhaust band clamp and aircraft control not possible by the pilot due to the fire.NTSB CHI02LA035Accident · No injuriesLimited investigationFinal reportBeech 76 · Greenwood, INthe directional control not maintained by the pilot. A contributing factor was the stuck open intake valve on the left engine.NTSB CHI02FA025Accident · 2 fatalField investigationFinal reportCessna 150M · Dyer, INThe failure of the flight crew to maintain adequate airspeed, resulting in an inadvertent stall/spin and the flight instructor's inadequate supervision of the flight, his impairment due to the use of over-the-counter medication is a contributing factor.NTSB CHI02LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Wayne, INThe pilot not maintaining control of the airplane during an attempted go-around. A factor was the trees.NTSB CHI02LA008Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Jeffersonville, INThe dual student pilot's failure to maintain control of the helicopter, his failure to maintain altitude/clearance from the terrain, and the inadequate supervision by the flight instructor. A factor was the gusty wind condition.NTSB CHI01LA331Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Indianapolis, INthe inadequate crew/group coordination and the parking brakes not set by the pilot in command.NTSB CHI01LA328Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Lebanon, INThe unsuitable terrain for landing encountered by the pilot. Factors were the carburetor icing conditions, the carburetor ice, and the bean crop.NTSB CHI01LA317Accident · No injuriesLimited investigationFinal reportBeech 200 · Indianapolis, INThe pilot not maintaining the proper ILS glide slope during the approach and the pilot not executing a missed approach. Contributing to the accident was the rain/mist.NTSB CHI01LA275Accident · Serious injuriesLimited investigationFinal reportSchuetz Miniplane DSA-1 · Michigan City, INAircraft control not being maintained by the pilot. Contributing factors to the accident were the pilot maneuvering at a low airspeed, the encountered stall/spin, and the recovery from the spin at a low altitude, which resulted in altitude/clearance not being…NTSB CHI01FA257Accident · 2 fatalField investigationFinal reportSchweizer 269C · Waterloo, INAircraft control not maintained for undetermined reasons.NTSB CHI01LA260Accident · No injuriesLimited investigationFinal reportHauck Moffra P-13 · Linden, INthe loss of engine power due to carburetor ice. Contributing to the accident was the rough/uneven terrain condition encountered during the landing.NTSB CHI01FA256Accident · 2 fatalField investigationFinal reportBeech E55 · Rensselaer, INthe pilot's ostentatious display when he buzzed the farmstead and did not maintain clearance from the barn.NTSB CHI01LA249Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Jeffersonville, INThe airplane was struck by deer during landing roll at night. A factor was the dark night.NTSB CHI01LA261Accident · No injuriesLimited investigationFinal reportMcIntosh Steen Skybolt · Lebanon, INThe pilot misjudged his altitude during the landing. A factor was the soybean crop which the airplane contacted.NTSB CHI01LA222Accident · Minor injuriesLimited investigationFinal reportDruine Turbulent D-31 · Lebanon, INThe pilot not maintaining aircraft control while maneuvering during initial climb. Factors to the accident were the improperly serviced propeller that resulted in a pitch setting that was insufficient for normal flight.NTSB CHI01FA204Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Lafayette, INThe fuel exhaustion due to the pilot's alcohol impaired decision making. Additional factors were the trees and night.NTSB CHI01LA170Accident · No injuriesLimited investigationFinal reportCessna 150L · Munster, INEngine failure during takeoff due to water contaminating the fuel, the pilot's inadequate preflight planning/preparation, and the low altitude. Factors relating to this accident were the attempted emergency landing after takeoff and the fence.NTSB CHI01LA172Accident · Serious injuriesLimited investigationFinal reportShanklin RV-6A · Poseyville, INthe premature flare by the pilot.NTSB CHI01LA160Accident · No injuriesLimited investigationFinal reportCessna 140 · La Porte, INthe inadequate planned approach by the pilot. Contributing factors were the fuel starvation and tailwind.NTSB CHI01LA154Accident · Serious injuriesLimited investigationFinal reportBoeing B757-200 · Kokomo, INthe turbulence encountered during descent and the passenger failure to return to his seat.NTSB CHI01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Patriot, INthe inadequate rotation speed and compensation for wind conditions by the pilot. Contributing factors were the crosswind and gust.NTSB CHI01LA131Accident · 1 fatalLimited investigationFinal reportMadsen Lancair 320 · Valparaiso, INThe pilot not maintaining aircraft control during the initial climb after takeoff and the inadvertent stall/spin. A factor to the accident was the pilot's total lack of experience in accident airplane.NTSB CHI01LA120Accident · No injuriesLimited investigationFinal reportAmerican General AG5B · Culver, INthe wrong runway selected by the pilot which resulted in a tailwind landing condition. Factors to the accident were the tailwind, the wet runway, the reduced braking action, and the airport perimeter fence.NTSB CHI01LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Culver, INthe CFI delayed remedial action during the takeoff. Additional factors were the wrong runway was selected, the tailwind, and the trees.NTSB CHI01LA114Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Gary, INThe inadequate preflight performed by the pilot which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. Factors associated with the accident were the inaccurate fuel quantity indicator, the rock which resulted in the overload failure…NTSB CHI01LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culver, INthe proper glide path not attained by both pilots during a short field landing. The snow bank was a contributing factor.NTSB CHI01FA064Accident · 2 fatalField investigationFinal reportCessna 172K · Martinsville, INThe pilots decision not to fly to the alternate airport, his decision to continue the flight in known adverse weather conditions, spatial disorientation by the pilot, and his failure to maintain aircraft control. Factors were the low ceilings, the dark night,…NTSB CHI01TA063Accident · Serious injuriesFinal reportPiper PA-23 · Griffith, INThe unsuitable terrain for landing encountered by the pilot. Factors included the loss of power for undetermined reasons and the rough terrain.