NTSB investigations, IN
139 cases where NTSB found Environmental issues.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 14 |
| 2010 | 8 |
| 2011 | 8 |
| 2012 | 7 |
| 2013 | 4 |
| 2014 | 9 |
| 2015 | 9 |
| 2016 | 11 |
| 2017 | 11 |
| 2018 | 6 |
| 2019 | 7 |
| 2020 | 6 |
| 2021 | 9 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 6 |
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03')) 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 CEN24LA380Accident · Serious injuriesClass 3 · LimitedFinal reportXag P100 PRO · Francesville, INThe remote pilot’s in-flight loss of control of the unmanned aircraft due to GPS signal fluctuations, which resulted in a collision with, and serious injury to, a person assisting the operation.NTSB CEN24LA259Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Thorntown, INThe pilot’s failure to ensure that the load hose was disconnected from the helicopter before takeoff, which resulted in a loss of control after liftoff and a hard landing.NTSB CEN24LA209Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 90A · Hebron, INThe pilot’s failure to maintain clearance from powerlines while landing in a field.NTSB CEN24LA177Accident · No injuriesClass 4 · LimitedFinal reportZenith CH-750 · Seymour, INThe flight instructor’s failure to maintain clearance from a fence during a takeoff attempt.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 CEN24LA116Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CCX-2000 · Laotto, INThe pilot’s improper decision to continue an approach with his vision obscured by sun glare, which resulted in a collision with a tree.NTSB CEN24LA103Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Bremen, INThe collapse of the nose landing gear after it contacted soft terrain during the landing roll.NTSB CEN24LA032Accident · Minor injuriesClass 4 · LimitedFinal reportTom Hodgson 29 · Kokomo, INThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN24LA017Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Mitchell, INThe inflight collision with a bird while in cruise flight.NTSB CEN23LA384Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · West Lafayette, INAn in-flight collision with a bird during initial climb.NTSB CEN23LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 150D · New Haven, INThe pilot’s loss of directional control while landing, which resulted in a runway excursion, impact with corn stalks, and subsequent nose over.NTSB DCA23LA170Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Rushville, INAn encounter with clear air turbulence during descent.NTSB CEN22LA425Accident · No injuriesClass 4 · LimitedFinal reportSlipstream Revelation · Delphi, INA loss of engine power due to carburetor icing.NTSB CEN22LA292Accident · No injuriesClass 4 · LimitedFinal reportMagnaghi Aeronautica SKY Arrow LSA · West Lafayette, INThe pilot’s failure to maintain proper airspeed while landing in gusting winds, which resulted in a hard landing and a runway excursion.NTSB CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.NTSB CEN22LA142Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Kokomo, INThe pilot’s decision to perform the takeoff on the soft, wet, turf runway, with the tailwheel equipped airplane, which resulted in a nose-over.NTSB CEN22LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Washington, INThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions which resulted in a runway excursion.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 CEN22LA074Accident · No injuriesClass 4 · LimitedFinal reportMini-MAX 1600R Sport · South Bend, INThe pilot’s low-level flight and poor visual lookout which resulted in collision with a light pole on final approach and the pilot’s improper decision to operate an airplane under the influence of alcohol.NTSB CEN21LA400Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Fort Wayne, INThe total loss of engine power after takeoff due to the formation of carburetor ice while on the ground and the pilot’s failure to apply carburetor heat immediately before takeoff.NTSB CEN21LA340Accident · Serious injuriesClass 4 · LimitedFinal reportStephen L Kruer Superstol · Floyds Knobs, INThe pilot’s failure to maintain clearance from the trees during a go-around.NTSB CEN21LA318Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Nappanee, INThe pilot’s failure to maintain clearance from the tower during low-level agricultural operations.NTSB CEN21LA279Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Portland, INThe airplane’s collision with a deer on the runway during landing.NTSB CEN21LA262Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150H · Muncie, INThe non-certificated pilot's failure to maintain aircraft control on departure in high density altitude conditions which resulted in an aerodynamic stall.NTSB CEN21LA157Accident · Minor injuriesClass 4 · LimitedFinal reportPost Thorp T-18 · Indianapolis, INThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB CEN21LA136Accident · No injuriesClass 3 · LimitedFinal reportLearjet 55 · Jeffersonville, INThe flight crew’s failure to verify the correct runway for landing, which resulted in a landing on a snow contaminated runway and resulting damage to the airplane. The illumination of the lights associated with the closed runway contributed to the accident.NTSB CEN21LA068Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · French Lick, INThe pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel starvation.NTSB CEN21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Salem, INThe pilot’s failure to avoid an obstacle during his approach to land.NTSB CEN20LA407Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver MX II · Marengo, INA loss of engine power due to carburetor icing. Contributing to the accident was the pilot’s decision to operate the airplane in conditions conducive to carburetor icing without a carburetor heating system, contrary to the engine manufacturer’s guidance.NTSB CEN20LA401Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA32 · Kokomo, INThe pilot’s inadequate visual lookout, which resulted in a collision with a utility pole and the subsequent collision with terrain.NTSB CEN20LA118Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32R · Rensselaer, INThe non-instrument rated pilot’s failure to establish a climb while initiating a missed approach after conducting an instrument approach below weather minimums.NTSB CEN20CA112Accident · No injuriesData collectionFinal reportCessna 172 · Madison, INThe flight instructor's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and nose-over.NTSB GAA20CA063Accident · Minor injuriesData collectionFinal reportSikorsky S 58JT · Lebanon, INThe pilot's failure to maintain proper clearance from a tractor trailer during landing.NTSB GAA19CA569Accident · No injuriesData collectionFinal reportDiamond DA20 · Fort Wayne, INThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and impact with a tree during an off-airport landing.NTSB GAA19CA330Accident · No injuriesData collectionFinal reportDiamond DA20 · Terre Haute, INThe student pilot's failure to maintain the runway heading and to relinquish the flight controls to the flight instructor when told to do so while landing in gusting, crosswind conditions, which resulted in a runway excursion and impact with runway lighting.NTSB GAA19CA244Accident · No injuriesData collectionFinal reportCessna A185 · Valparaiso, INThe pilot's improper throttle application and subsequent failure to maintain directional control during the takeoff roll in gusting left crosswind conditions, which resulted in a ground loop.NTSB GAA19CA215Accident · No injuriesData collectionFinal reportKaminskas RTH Jungster 1 · Lebanon, INThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB CEN19FA084Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Goshen, INThe pilot’s failure to maintain adequate altitude for undetermined reasons during a practice circling approach in dark night visual meteorological conditions, which resulted in a collision with power lines.NTSB CEN19LA090Accident · No injuriesClass 2 · LimitedFinal reportBeech 400 · Richmond, INThe flight crew's decision to continue an unstable approach under conditions that exceeded the airplane's landing performance capabilities, which resulted in a runway overrun and impact with terrain.NTSB ERA19LA022Accident · No injuriesLimited investigationFinal reportPiper PA22 · Brownstown, INThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the outcome was the student…NTSB CEN18LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rushville, INLoss of engine power due to carburetor icing and the pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.NTSB CEN18TA233Accident · Serious injuriesFinal reportCessna 150F · Ferdinand, INThe pilot's failure to apply carburetor heat in conditions conducive to the accumulation of carburetor icing, which resulted in a total loss of engine power.NTSB GAA18CA277Accident · No injuriesData collectionFinal reportCessna 162 · Waterloo, INThe pilot’s improper landing flare during a soft-field landing and his use of an improper soft-field landing procedure, which resulted in a bounced landing.NTSB CEN18FA132Accident · 2 fatalField investigationFinal reportCessna 150 · Marion, INThe failure of both pilots to see and avoid the other airplane as they converged on intersecting runways. Contributing to the accident was the jet pilot's not monitoring the airport's traffic advisory frequency, known reduced visibility of the intersecting…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 CEN18LA062Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 525A · Michigan City, INThe flight crew's improper decision to land on a snow-covered runway that had insufficient runway distance for the airplane to land with the contamination, which resulted in a runway overrun and impact with obstacles.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 GAA17CA401Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Paoli, INThe pilot's decision to maneuver an overgross weight helicopter at a low altitude and airspeed with a gusting tailwind, which resulted in a high descent rate and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to…NTSB GAA17CA336Accident · No injuriesData collectionFinal reportPiper PA 28 · Auburn, INThe pilot’s decision to continue to attempt to take off despite the airplane’s inability to attain a positive climb rate, which resulted in little runway remaining, and his subsequent decision to turn off the runway, which resulted in a collision with a barn.NTSB CEN17LA205Accident · No injuriesLimited investigationFinal reportAmstutz Curtis J BD-5B · Portland, INA failure of the wiring between the engine control unit and the fuel injector, which resulted in a total loss of engine power.