Fatal NTSB investigations, IN
41 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 7 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2024 | 3 |
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 c.\"eventStateOrRegion\" = 'IN' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 c."eventStateOrRegion" = 'IN' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN24FA346Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Sulphur Springs, INThe pilot’s loss of directional control during takeoff for undetermined reasons.NTSB CEN24FA340Accident · 4 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Anderson, INThe pilot’s inadequate airspeed management during the missed approach which resulted in an inadvertent aerodynamic stall and loss of control at low altitude.NTSB CEN24LA144Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · Muncie, INThe pilot’s spatial disorientation and subsequent loss of control while maneuvering outside established instrument approach procedures in instrument meteorological conditions, which resulted in an impact with terrain. Contributing to the accident was the…NTSB CEN22FA080Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Bloomington, INThe pilot’s failure to follow the instrument landing system (ILS) course guidance, which resulted in the pilot’s loss of airplane control during the instrument approach. Contributing to the accident was the presence of turbulence and low-level wind shear.NTSB CEN20LA304Accident · 1 fatalClass 3 · LimitedFinal reportBrantly B2B · Monrovia, INThe pilot’s loss of control after takeoff for reasons that could not be determined based on the available information.NTSB CEN20FA002Accident · 1 fatalClass 3 · FieldFinal reportPiper Aerostar 602P · Kokomo, INThe pilot's exceedance of the airplane’s critical angle of attack following a dual engine power loss caused by the line service technician fueling the airplane with the wrong fuel, which resulted in an aerodynamic stall and subsequent loss of control.…NTSB CEN19FA195Accident · 1 fatalClass 2 · FieldFinal reportRans S12 · Orleans, INThe pilot's exceedance of the airplane's critical angle of attack while maneuvering toward the runway, which resulted in an aerodynamic stall and a loss of control.NTSB CEN19FA044Accident · 1 fatalField investigationFinal reportPiper PA24 · Valparaiso, INThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.NTSB CEN19FA036Accident · 3 fatalClass 3 · FieldFinal reportCessna 525 · Memphis, INThe pilot’s inability to regain airplane control after a left roll that began for reasons that could not be determined based on the available evidence.NTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…NTSB CEN18FA282Accident · 1 fatalField investigationFinal reportFisher Celebrity · Patriot, INAn in-flight separation of the right wing due to upward and rearward bending that led to an overstress fracture. The reason for the upward and rearward bending could not be determined based on the available information.NTSB CEN18FA258Accident · 1 fatalField investigationFinal reportBell 47G · Arlington, INThe inflight separation of the upper transmission due to the thread failure of transmission housing attachment bolts, which were installed on the helicopter with thread damage from a prior installation.NTSB CEN18FA107Accident · 3 fatalField investigationFinal reportCessna 441 · Rossville, INAn in-flight loss of control for reasons that could not be determined based on the available evidence.NTSB CEN18FA088Accident · 1 fatalField investigationFinal reportCessna 172F · Williamsport, INThe pilot's mismanagement of fuel, which resulted in fuel exhaustion and descent and collision with trees.NTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…NTSB CEN17FA334Accident · 1 fatalField investigationFinal reportVans RV-12 · Fishers, INThe pilot's failure to latch the canopy before takeoff, and his failure to maintain pitch control following the in-flight opening of the canopy during the initial climb resulting in a subsequent impact with terrain and ground fire.NTSB CEN17FA152Accident · 1 fatalField investigationFinal reportTemco GC 1B · Hartsville, INThe pilot's loss of control after exceeding the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB CEN17FA046Accident · 1 fatalField investigationFinal reportGordon Pegazair P 100 · Mt Vernon, INThe pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.NTSB CEN15FA194Accident · 1 fatalField investigationFinal reportS C Aerostar S A YAK 52TW · Advance, INThe pilot’s loss of airplane control while maneuvering for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.NTSB CEN15LA026Accident · 1 fatalLimited investigationFinal reportStephenson Stol CH 701 · Mount Vernon, INThe pilot’s impairment due to the ingestion of alcohol and sedating medications, which led to her improper decision to conduct low-level flight, affected her ability to safety operate the airplane, and resulted in her failure to maintain clearance from power…NTSB CEN14LA504Accident · 2 fatalLimited investigationFinal reportSaccio Thomas A Seawind 3000 · Bloomington, INAn in-flight fire for reasons that could not be determined because the examination of the airplane did not reveal the source of the fire.NTSB CEN14FA356Accident · 1 fatalField investigationFinal reportMooney M20M · Greenwood, INA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. Also causal to the accident was the pilots' decision…NTSB CEN14LA243Accident · 1 fatalLimited investigationFinal reportHoffius Stowe Challenger II · Attica, INThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude, which led to an aerodynamic stall and loss of control. Contributing to the accident was the installation of an…NTSB CEN13FA446Accident · 1 fatalField investigationFinal reportCampbell Earl S JR RV-6A · Knox, INThe incapacitation of the pilot due to a cardiovascular event that prevented him from maintaining control of the airplane during the landing approach.NTSB CEN13LA433Accident · 1 fatalLimited investigationFinal reportClayton Gerald H Glastar GS-1 · Columbus, INSlippage in the engine clutch and gear reduction module and a resultant uncommanded movement of the propeller blades into reverse thrust.NTSB CEN13LA428Accident · 1 fatalLimited investigationFinal reportCooper, David W. Challenger II · Mill Creek, INThe noncertificated pilot's improper fuel planning, which led to fuel exhaustion and a loss of engine power. Contributing to the accident was the pilot's failure to obtain adequate instruction or an endorsement to solo in the accident airplane model, which…NTSB CEN13FA196Accident · 2 fatalField investigationFinal reportHawker Beechcraft 390 · South Bend, INThe private pilot's inadequate response to the dual engine shutdown during cruise descent, including his failure to adhere to procedures, which ultimately resulted in his failure to maintain airplane control during a single-engine go-around. An additional…NTSB CEN13FA085Accident · 4 fatalField investigationFinal reportPiper PA 46-350P · Greensburg, INThe pilot's failure to maintain airplane control while maneuvering in night instrument meteorological conditions due to spatial disorientation.NTSB CEN13FA002Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Gary, INThe pilot's loss of control during an instrument approach due to spatial disorientation. Contributing to the accident were deficient approach control services and the pilot's loss of positional awareness.NTSB CEN12FA143Accident · 2 fatalField investigationFinal reportCessna 177A · North Vernon, INThe non-instrument-rated pilot's decision to fly into known instrument meteorological conditions, which resulted in the pilot's spatial disorientation and loss of airplane control.NTSB CEN11FA645Accident · 2 fatalField investigationFinal reportRemos Aircraft Gmbh Flugzeugba GX · Noblesville, INThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude. Contributing was the pilot's decision to maneuver at an altitude below that required for congested areas, which did not afford an adequate margin for stall recovery.NTSB CEN11FA468Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Rising Sun, INThe noninstrument-rated pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and failure to maintain clearance from terrain.NTSB CEN11FA267Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · South Bend, INThe pilot’s failure to maintain airplane control while on final approach with a gusting crosswind and the subsequent aerodynamic stall and spin during the attempted go-around.NTSB CEN11FA201Accident · 1 fatalField investigationFinal reportCessna 421C · Connersville, INThe pilot did not maintain control of the airplane while making a low-altitude turn during dark night conditions.NTSB CEN11LA194Accident · 1 fatalLimited investigationFinal reportTaylorcraft DCO-65 · Americus, INThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB CEN10LA526Accident · 1 fatalLimited investigationFinal reportThompson Kolb Twinstar Mark · Elkhart, INThe pilot's failure to maintain control of the airplane during the landing approach.NTSB CEN10LA442Accident · 1 fatalLimited investigationFinal reportLunceford Sparrowhawk II · Tell City, INThe pilot's loss of control of the gyroplane for undetermined reasons.NTSB CEN10FA233Accident · 2 fatalField investigationFinal reportJetProp DLX Piper PA46 · New Albany, INThe pilot’s failure to maintain airspeed in instrument meteorological conditions, which resulted in an aerodynamic stall.NTSB CEN10LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain control of the airplane. Contributing to the accident was the pilot’s decision to conduct the flight with known physiological impairment and his use of unapproved sedating medication, both of which likely impaired his ability…NTSB CEN09LA543Accident · 2 fatalLimited investigationFinal reportSportflight International Astra HKS · Bloomfield, INThe pilot's failure to maintain control of the airplane while maneuvering.NTSB CHI08FA269Accident · 3 fatalField investigationFinal reportBell 206L-1 · Greensburg, INThe in-flight separation of a main rotor blade due to a fatigue failure of the blade spar, rendering the helicopter uncontrollable, and the manufacturer's production of main rotor blades with latent manufacturing defects, which precipitated the fatigue…