NTSB investigations, IN
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, newest first
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' 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' 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 CHI95IA045Incident · No injuriesIncident investigationFinal reportFokker F-28-4000 · Evansville, INthe failure of company maintenance personnel to adequately service (fill) the horizontal stabilizer drive actuator with hydraulic fluid.NTSB CHI95LA036Accident · 1 fatalLimited investigationFinal reportLessel KR-2 · Portland, INthe failure of the elevator control cable attach point and the pilot's subsequent inability to control the airplane.NTSB CHI95LA034Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Mc Cordsville, INthe pilot's improper use of the cyclic control. Factors were the diversion of attention and total lack of experience in the type of aircraft, by the pilot.NTSB DCA95MA001Accident · 68 fatalClass 1 · MajorFinal reportATR ATR-72-212 · Roselawn, INthe loss of control, attributed to a sudden and unexpected aileron hinge moment reversal that occurred after a ridge of ice accreted beyond the deice boots while the airplane was in a holding pattern during which it intermittently encountered supercooled…NTSB CHI95LA020Accident · No injuriesLimited investigationFinal reportCessna 182P · Bremen, INthe pilot's failure to perform a go-around prior to touchdown. Factors to the accident were the tailwind, excessive airspeed, the rough terrain and the powerlines.NTSB CHI95FA018Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Sellersburg, INFailure of the pilot to follow IFR procedures by allowing the aircraft to deviate left of the ILS localizer course, by not maintaining the proper ILS glide path, and by continuing descent below the ILS decision height.NTSB CHI95LA016Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Ft. Wayne, INthe in-flight collision with birds(geese). A factors associated with the accident was the building which was contacted.NTSB CHI95LA006Accident · Serious injuriesLimited investigationFinal reportJohnson A-4 · Laporte, INthe pilot's inadvertant stall of the airplane while conducting a forced landing. A factor was the engine failure which occurred for an undetermined reason.NTSB CHI95FA002Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Martinsville, INThe pilot's impairment of judgment and performance due to alcohol, improper planning/decision, and failure to maintain sufficient altitude/clearance above the ground.NTSB CHI95LA004Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cloverdale, INthe total loss of engine power due to a blocked orifice in the fuel pump. A related factor is the rough/uneven terrain encountered during the forced landing.NTSB CHI94DET02Accident · Minor injuriesFinal reportSimcox Sport Trainer · Laporte, INThe pilot's continued operation with a known power deficiency. The loss of engine power was a factor in the accident.NTSB CHI94LA349Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Williamsport, INThe continued flight into adverse weather conditions, the student's failure to maintain a proper glideslope and the CFI's delay in initiating remedial action. Factors related to the accident were the lightning and turbulent thunderstorm conditions.NTSB CHI94LA348Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dale, INthe pilot's failure to assure an adequate fuel supply for the flight. Factors associated with the accident were poor preflight planning, inattentiveness to the fuel supply during the flight, the ditch, and the utility pole which was contacted during the…NTSB CHI94LA341Accident · No injuriesLimited investigationFinal reportDooley, James M Velocity · Valparaiso, INthe pilot-in-command's improper use of the elevator trim. A factor was the pilot-in-command's lack of total experience in type of aircraft.NTSB CHI94LA335Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · W. Lafayette, INThe pilot's improper level-off and recovery from a bounced landing. A factor in the accident was the pilot's lack of training for recovery from bounced landings and/or aborted takeoffs.NTSB CHI94LA333Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Elkhart, INthe pilot's improper use of the fuel selector position which resulted in fuel starvation.NTSB CHI94LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Decatur, INthe pilot-in-command's failure to maintain a proper altitude and his inadequate visual outlook. A factor was the tower.NTSB CHI94LA306Accident · No injuriesLimited investigationFinal reportCessna 182 · Indianapolis, INthe pilot's improper use of the mixture control, the poorly planned approach and the inadvertent stall.NTSB CHI94LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · Fort Wayne, INthe loss of engine power due to the failure of the number one cylinder.NTSB CHI94LA270Accident · No injuriesLimited investigationFinal reportMiller Kitfox · Spencer, INthe private pilot/airplane builder's failure to maintain adequate clearance from obstacles during the approach to landing.NTSB CHI94LA257Accident · Minor injuriesLimited investigationFinal reportLattimore-Dwyer Breezy · Goshen, INfuel exhaustion which resulted from the pilot's failure to assure an adequate fuel supply for the flight.NTSB CHI94LA242Accident · No injuriesLimited investigationFinal reportGrumman FM-2 · Woodburn, INthe total failure of the throttle linkage arm.NTSB FTW94LA229Accident · Serious injuriesLimited investigationFinal reportBoeing 737-2H4 · South Bend, INThe encounter with unforcasted and unreported turbulence.NTSB CHI94LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Station, INthe pilot-in-command's inattention to the fuel supply. A factor was rough and uneven terrain.NTSB CHI94LA203Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Terre Haute, INthe pilot-in-command's inadvertant stall of the airplane. A factor associated with the accident was the elevator trim position.NTSB CHI94LA187Accident · No injuriesLimited investigationFinal reportBeech C-23 · Gary, INImproper preflight planning and preparation by the pilot-in-command which resulted in fuel exhaustion. A factor associated with the accident was the delay in emergency procedures by the pilot-in-command.NTSB CHI94LA188Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · New Paris, INthe pilot's inadequate visual lookout. Factors associated with the accident are a fence post, and the pilot's lack of familiarity with the geographic area (landing environment).NTSB CHI94LA192Accident · No injuriesLimited investigationFinal reportClassic YMF-5 · Noblesville, INthe pilot's excessive use of brakes. Factors related to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.NTSB CHI94LA178Accident · 1 fatalLimited investigationFinal reportCessna 150L · Richmond, INInadequate visual lookout by the pilots of both airplanes.NTSB CHI94LA169Accident · No injuriesLimited investigationFinal reportCessna 150K · Jasonville, INthe loss of engine power due to fuel exhaustion as a result of an inadequate aircraft preflight inspection.NTSB CHI94LA136Accident · No injuriesLimited investigationFinal reportCessna 150A · Angola, INthe on ground collision of the airplane with a deer. A factor was the dark night.NTSB CHI94LA127Accident · No injuriesLimited investigationFinal reportBeech 35 · Anderson, INthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the rough terrain encountered following the loss of control.NTSB CHI94IA111Incident · No injuriesIncident investigationFinal reportBeech BE200 · Rochester, INthe airplane painter/refinishers' failure to follow appropriate procedures/directives pertinent to the masking, stripping, painting and cleaning of the airplane cabin windows, which resulted in the in-flight failure of the right aft cabin window. A related…NTSB CHI94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Lebanon, INInadequate preflight preparation by the pilot-in-command. Factors were fuel system contamination and an unsuitable terrain encountered by the pilot-in-command during a forced landing.NTSB CHI94FA080Accident · 1 fatalField investigationFinal reportCessna 320F · Goshen, INthe pilot-in-command's continued operation with known deficiencies in equipment. Factors were ice on the windshield and the pilot-in-commands visual outlook not possible.NTSB CHI94LA074Accident · No injuriesLimited investigationFinal reportDouglas DC3C · Anderson, INthe pilot in command's inadequate remedial action after a loss of directional control during the takeoff ground roll. Related factors are the copilot's failure to maintain directional control, and the snow covered, icy runway.NTSB CHI94IA066Incident · No injuriesIncident investigationFinal reportBritish Aerospace ATP · South Bend, INan internal failure of the auxiliary power unit.NTSB CHI94LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Highland, INAn electrical system failure due to a fractured alternator mounting lug. Factors related to the accident were the rough terrain, and decreasing visibility due to snow and darkness.NTSB CHI94LA047Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Ashley, INInadequate aircraft preflight by the pilot-in-command. A factor relating to this accident is the dark night.NTSB CHI94FA036Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Cedar Lake, INthe failure of the pilot to maintain proper altitude. A factor related to the accident was flight into known adverse weather by the pilot.NTSB CHI94MA032Accident · 5 fatalMajor investigationFinal reportCessna 421B · Greensburg, INan inadvertent stall by the pilot in command. Factors associated with the accident are the icing conditions and low ceilings.NTSB CHI94LA030Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Valparaiso, INThe pilot's inadequate compensation for wind conditions while landing in a gusty crosswind. Factors associated with the accident are the gusty crosswind and the pilot's lack of experience in this type airplane.NTSB CHI94LA008Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Bristol, INthe pilot's abrupt maneuver (intentional swerve) and main gear collapse during the landing roll on a short grass strip.NTSB CHI94LA003Accident · No injuriesLimited investigationFinal reportWelch OW8M · Greenfield, INThe pilot's failure to properly flare the airplane. The gusty crosswind was a factor.NTSB CHI93LA376Accident · No injuriesLimited investigationFinal reportCessna 150H · Gary, INan improper climb airspeed established by the pilot-in-command after banner pickup.NTSB CHI93LA374Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe pilot-in-command's failure to maintain airspeed. Factors were his lack of total experience and his premature retraction of the flaps.NTSB CHI93IA372Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Indianapolis, INan undetermined problem which resulted in the physical impairment of flight attendants, passengers and the first officer.NTSB CHI93LA373Accident · No injuriesLimited investigationFinal reportBeech 18-C45G · Jeffersonville, INthe mechanical binding of the landing gear extension mechanism.NTSB CHI93LA363Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INthe improper recovery from a bounced landing by the pilot-in- command.NTSB CHI93LA362Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Hobart, INThe certificated flight instructor's inadequate supervision of the flight during a simulated single engine approach and landing.