NTSB investigations, 2002, IN
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 2002
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") = 2002 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 CHI03LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Greensburg, INFailure of the pilot to maintain directional control during the takeoff roll. Contributing factors included inadequate planning/decision by the pilot for attempting to depart from the slush covered runway, the slush covered runway itself, and the falling snow.NTSB CHI03LA032Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Jeffersonville, INThe mechanical binding of the left main landing gear, which resulted in the left main landing gear not fully extending to the down-and-locked position. Factors to the accident were the oleo-strut linkage being corroded and the contamination of the gear…NTSB CHI03LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Wheatfield, INThe pilot not maintaining aircraft control and the pilot's inadequate compensation for the gusting wind condition. Factors to the accident were the gusting wind condition and the inadvertent stall at a low altitude.NTSB CHI03LA009Accident · Minor injuriesLimited investigationFinal reportDavis Early Bird Jenny · Scottsburg, INThe pilot not maintaining aircraft control. Factors to the accident included the pilot's lack of familiarity with the airplane, which resulted in an inadvertent stall/spin at a low altitude.NTSB CHI02FA294Accident · 2 fatalField investigationFinal reportAviat S-2C · Sheridan, INThe pilot's failure to maintain adequate altitude and airspeed while performing an aerobatic maneuver. Contributing factors were the pilot-in-command exceeding the aircraft weight and balance, and his inadequate preflight planning/preparation.NTSB CHI02LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Elwood, INThe pilot's misjudgment of speed/distance and his failure to perform a go-around. The pilot's inaccurate evaluation of the wind, a tailwind, selection of the wrong runway, and wet grass are contributing factors.NTSB CHI02LA264Accident · No injuriesLimited investigationFinal reportCessna 182S · Fishers, INThe pilot failed to maintain clearance with the light pole while taxiing. A factor was the light pole.NTSB CHI02FA197Accident · 1 fatalField investigationFinal reportPiper PA-60 · Columbus, INThe pilot's failure to maintain control of the airplane during a missed approach. Additional factors included the operator's inadequate oversight, the pilot's improper in-flight decision, conditions conducive to pilot fatigue, fog, and night.NTSB CHI02LA190Accident · No injuriesLimited investigationFinal reportCessna 150F · Ft. Wayne, INThe corroded throttle cable resulting in a loss of engine power. Factors were the inadequate annual inspection, the unsuitable terrain encountered during the forced landing, the ditch, and the fence.NTSB CHI02FA189Accident · 1 fatalField investigationFinal reportSikorsky S-58ET · Brookville, INThe pilot's intentional low altitude fight and his failure to maintain clearance from power transmission lines. Factors to the accident were the power transmission lines followed by the inability to control the aircraft after the collision with power…NTSB CHI02LA157Accident · No injuriesLimited investigationFinal reportMaule M-7-260C · Fishers, INThe pilot not performing a go-around prior to exceeding the proper touchdown point and the pilot not maintaining altitude/clearance from the trees. Factors to the accident were the pilot's inadequate preflight planning and the trees.NTSB CHI02LA155Accident · Serious injuriesLimited investigationFinal reportAeronca O-58B · Alexandria, INThe pilot's failure to maintain adequate airspeed which resulted in a stall. A factor was the low altitude.NTSB CHI02LA142Accident · No injuriesLimited investigationFinal reportBell 47G-4 · Muncie, INThe pilot did not maintain directional control during hover taxi. Inadequate compensation for the crosswind conditions, the light rain, and the light pole were factors in the accident.NTSB CHI02FA140Accident · 1 fatalField investigationFinal reportSchutte Ms. Ryan Special · Anderson, INThe pilot's failure to properly install the canard attach bolts prior to the flight and the resulting inflight separation of the canard.NTSB CHI02LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Angola, INThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain condition.NTSB CHI02LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe pilot's improper fuel management resulting in the total loss of engine power due to fuel starvation and the pilot's failure to use the checklist.NTSB CHI02LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Valparaiso, INThe pilot not maintaining aircraft control while encountering windshear during initial climbout, resulting in a stall at a low altitude.NTSB CHI02LA104Accident · Serious injuriesLimited investigationFinal reportHoagland Varieze · Gary, INThe pilot was unable to maintain directional control of the airplane during the forced landing due to a locked brake. Factors associated with the accident were the pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion and the…NTSB CHI02LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Fulton, INA loss of engine power due to excessive clearance of the connecting rod bearing resulting in engine seizure. A related factor was the muddy field.NTSB CHI02FA097Accident · No injuriesField investigationFinal reportMitsubishi MU-300 · Anderson, INMissed approach not executed and flight to a destination alternate not performed by the flight crew. The tail wind and snow/ice covered runway were contributing factors.NTSB CHI02FA094Accident · 2 fatalField investigationFinal reportPiper PA-31P · Daleville, INThe pilots failure to maintain control of the airplane during the instrument approach. The low overcast ceiling and the pilot's in-flight decision to execute the instrument approach in below minimum weather conditions were factors.NTSB CHI02LA082Accident · No injuriesLimited investigationFinal reportCessna 182T · Franklin, INThe proper glidepath not attained, the excessive airspeed, and the pilot failed to attain clearance from the trees during the aborted landing. An additional factor was the trees.NTSB CHI02LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Bloomington, INThe pilot's inadequate recovery from a bounced landing which resulted in a hard contact with the runway. Factors associated with the accident were the improper flare and the crosswind condition.NTSB CHI02LA069Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-41 · Indianapolis, INThe passenger fell off the side of the slide during the emergency evacuation. Factors were the emergency evacuation and the erratic ignition exciter.NTSB CHI02LA051Accident · No injuriesLimited investigationFinal reportBeech S35 · Angola, INThe pilot 's failure to maintain adequate airspeed and encountered a stall on approach to land. The low altitude on final approach was a factor.