NTSB investigations, 1997, 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\") = 1997
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") = 1997 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 CHI98FA068Accident · 1 fatalField investigationFinal reportBeech C35 · Evansville, INImproper maintenance by the use of a loose fitting unapproved fuel line, which resulted in fuel starvation and the loss of engine power.NTSB CHI98LA040Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Salem, INthe pilot's misjudgment of distance and altitude, while on final approach to land at night. Factors relating to the accident included: an undetermined electrical malfunction, inoperative flaps, darkness, the pilot not using the landing light, and the…NTSB CHI98LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Plymouth, INthe pilot's failure to maintain control of the airplane during the crosswind, soft field takeoff. Factors in this accident were the pilot not following the airplane manufacturer's recommended takeoff procedures by lowering the flaps, and the crosswind.NTSB CHI98FA031Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Lynn, INthe pilot's failure to maintain control of the airplane which resulted in the inflight separation of the wings, vertical stabilizer/rudder, and the stabilator. Factors associated with the accident the pilot continued the flight into known adverse weather and…NTSB CHI98LA014Accident · 2 fatalLimited investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain adequate airspeed during a go-around attempt which resulted in an inadvertent stall.NTSB CHI98LA006Accident · Serious injuriesLimited investigationFinal reportBeech V35A · West Lafayette, INthe pilot's improper decision not to land before his airplane ran out of fuel, fuel exhaustion and the inadvertent stall.NTSB CHI98LA008Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Cloverdale, INthe Boeing pilot failed to identify the Waco airplane on the runway before initiating a takeoff. Factors related to the accident were: the restricted forward visibility of both pilots due to the tailwheel configurations of both airplanes.NTSB CHI97LA297Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INthe pilot's improper planning/decision and failure to refuel the airplane in a timely manner, which resulted in fuel exhaustion. A related factor was: trees in the emergency landing area.NTSB CHI97LA295Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Greenwood, INthe student pilot's failure to maintain adequate airspeed during the go-around, which resulted in an inadvertant stall. A factor related to the accident was the raising of flaps.NTSB CHI97FA290Accident · 3 fatalField investigationFinal reportBeech 76 · West Lafayette, INthe inadvertent stall. A related factor was the instructor pilot's failure to ensure the elevator trim was reset for takeoff.NTSB CHI97FA272Accident · 1 fatalField investigationFinal reportKellums Sonerai 1 · Scottsburg, INa loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed greater than the stalling speed for the airplane. A factor relating to this accident was the student pilot's lack of total experience.NTSB CHI97LA271Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Zionsville, INfailure of the pilot to maintain adequate airspeed, which resulted in a stall and subsequent spin. A factor associated with the accident was the pilot's lack of experience in this make and model of glider.NTSB CHI97LA255Accident · No injuriesLimited investigationFinal reportTaylorcraft L2A · Shelbyville, INthe inadequate preflight by the pilot and the loose fuel line fitting.NTSB CHI97LA232Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Auburn, INan improper flare by either this pilot or the pilot of a previous flight, which resulted in a hard landing and overload damage to the right main landing gear. The pilot's continued operation with a known deficiency may have been a related factor.NTSB CHI97FA208Accident · 1 fatalField investigationFinal reportCessna 150F · Gary, INthe pilot's not obtaining/maintaining airspeed which resulted in a stall.NTSB CHI97IA205Incident · No injuriesIncident investigationFinal reportBoeing B-727-200 · Indianapolis, INthe improper installation of the incorrect spherical bearing by the company's maintenance personnel. A factor was the improper plating of the trunnion with chromium by the landing gear overhaul facility.NTSB CHI97LA202Accident · Minor injuriesLimited investigationFinal reportNiquette Pietenpol GN-1 · Lake Village, INthe pilot's inability to maintain sufficient airspeed and climb.NTSB CHI97LA179Accident · No injuriesLimited investigationFinal reportCessna A150M · Cumberland, INthe pilot's failure to use (or improper use of) carburetor heat. Factors associated with the accident were: carburetor icing (weather) conditions, and the lack of airspeed (or altitude) to clear an obstruction (barn) without stalling the airplane.NTSB CHI97LA168Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Franklin, INthe instructor pilot stalled the aircraft as a result of inadequate preflight planning. Factors included the transmission wire, the rising terrain, and the trees at the departure end of the runway.NTSB CHI97LA163Accident · 1 fatalLimited investigationFinal reportSiefert 5151RG · Shelbyville, INthe cause of the accident is undetermined.NTSB CHI97LA162Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Valparaiso, INa delay by the pilot of the other aircraft in turning on his mode C transponder.NTSB CHI97LA154Accident · No injuriesLimited investigationFinal reportCessna 340A · Fort Wayne, INthe pilot did not comply with the decision height and his attention was diverted from his cockpit scan. The factors involved were the weather conditions were at landing minimums and a flight to his destination alternate was not performed.NTSB CHI97LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Arcadia, INimproper planning/decision by the pilot. Factors related to the accident were: the pilot's selection of the wrong runway for takeoff, and the resultant tailwind.NTSB CHI97LA140Accident · 1 fatalLimited investigationFinal reportAerospatiale AS-365-N2 · Indianapolis, INinadequate visual clearance by the passenger resulting in his being struck with the rotor blade. A factor relating to this accident was the gusting winds.NTSB CHI97LA137Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Paragon, INthe pilot did not maintain aircraft control. The factors involved were aerobatics were performed and improper use of aircraft.NTSB CHI97LA135Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Angola, INthe pilot's improper recovery from a bounced landing. Factors associated with the accident were the tailwind, the pilot's selection of runway, and the misjudged landing flare.NTSB CHI97LA129Accident · No injuriesLimited investigationFinal reportBeech B33-35 · Mishawaka, INImproper flare. A factor associated with the accident was the gusty, crosswind condition.NTSB CHI97LA114Accident · Serious injuriesLimited investigationFinal reportOlsen Acro Sport II · Monon, INThe loss of engine power for undetermined reasons. Low altitude flight is a contributing factor.NTSB CHI97GA103Accident · Serious injuriesFinal reportBell OH-58A · Seymour, INimproper action(s) by one or more of the emergency response team members, during a hovering/loading sequence, which resulted in the helicopter's lateral center-of-gravity (CG) limitations to be exceeded. A factor associated with the accident was: the pilot's…NTSB CHI97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INa fatigue failure of the fight main landing gear strut/spar attachment screws.NTSB CHI97FA093Accident · 1 fatalField investigationFinal reportStinson 108 · Greenfield, INa loss of engine power due to restricted movement in the exhaust valve and rotted/weathered ignition harness, and the pilot's failure to maintain airspeed which resulted in an inadvertant stall.NTSB CHI97LA089Accident · No injuriesLimited investigationFinal reportCessna 150 · Petersburg, INThe pilot's failure to maintain adequate airspeed, which resulted in a stall. Low altitude flight is a contributing factor.NTSB CHI97LA086Accident · No injuriesLimited investigationFinal reportGrumman American AG5B · Greencastle, INThe student pilot's improper recovery from a bounced landing.NTSB CHI97LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INthe pilot's inadequate fuel management and fuel system exhaustion. A factor involved was the inadequate in-flight planning/decision.NTSB CHI97LA057Accident · No injuriesLimited investigationFinal reportBeech 300 · Bloomington, INthe pilot's excessive distance/speed during the landing which led to his failure to attain a proper touchdown point on the runway. The factors involved were: the pilot's inadequate in-flight planning/decision, his failure proceed to the destination airport,…NTSB CHI97LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · Bloomington, INthe pilot failed to maintain control of the aircraft. Factors included the icy runway and the crosswind.