Skip to content

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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

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 CHI93LA359Accident · No injuriesLimited investigationFinal reportCessna 172F · Indianapolis, INThe failure of the left magneto, which resulted in a partial loss of engine power.Sep 12, 1993 · N5678R · Substantial damage NTSB CHI93LA338Accident · No injuriesLimited investigationFinal reportBeech 19 · Elkhart, INinadequate remedial action by the flight instructor. Factors related to the accident were the excessive descent rate and the overload failure of the landing gear.Aug 26, 1993 · N1914L · Substantial damage NTSB CHI93LA335Accident · No injuriesLimited investigationFinal reportCessna 150J · Rochester, INthe commercial pilot's inadequate preflight planning/preparation.Aug 22, 1993 · N74GT · Substantial damage NTSB CHI93LA297Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Lafayette, INthe loss of engine power for reason or reasons undetermined.Aug 8, 1993 · N958MQ · Substantial damage NTSB CHI93LA289Accident · No injuriesLimited investigationFinal reportChampion 402 · Valparaiso, INFailure of the exhaust stack assembly.Jul 27, 1993 · N9981Y · Substantial damage NTSB CHI93LA284Accident · No injuriesLimited investigationFinal reportCessna 177RG · Columbus, INthe pilot in command's failure to maintain proper clearance. A factor involved in this accident is the pilot in command's failure to maintain a proper glidepath.Jul 26, 1993 · N1850Q · Substantial damage NTSB CHI93FA274Accident · 2 fatalField investigationFinal reportCessna A150K · Goshen, INFailure of both pilots to see and avoid each other. A factor in the accident was the position of the sun which resulted in sun glare for the pilot of the mong sport.Jul 25, 1993 · N8382M · 2 aircraft · Destroyed NTSB CHI93LA228Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Brownsburg, INfailure to replace a dirty air filter.Jun 25, 1993 · N89133 · Substantial damage NTSB CHI93FAMS4Accident · 1 fatalMissing aircraftFinal reportMooney M20K · Hobart, INundetermined.Jun 25, 1993 · N5655M · Destroyed NTSB CHI93LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INa misjudged flare and subsequent hard landing by the student pilot. A factor in the accident was the student pilot's failure to perform a go-around.May 30, 1993 · N2816A · Substantial damage NTSB CHI93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Jeffersonville, INThe flight instructor's delayed remedial action and failure to assure recovery from a bounced landing. A factor related to the accident was: improper flare by the student pilot.May 27, 1993 · N3109V · Substantial damage NTSB CHI93DEX01Accident · No injuriesFinal reportZeigler Moni · Seymour, INan inadvertent stall. Factors relating to the accident are the major alteration of the airframe, and failure of the pilot-in- command to obtain new performance data.May 6, 1993 · N10GZ · Substantial damage NTSB CHI93FA161Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paoli, INThe pilot-in-command's inadequate preflight preparations and his failure to maintain airspeed. Factors were the instructor's inadequate training of the pilot-in-command, unqualified maintenance personnel's inadequate inspection of the aircraft and the…May 5, 1993 · N2487T · Destroyed NTSB CHI93LA156Accident · No injuriesLimited investigationFinal reportBrantly-Hynes B2B · Greencastle, INContamination of the fuel system by particulate matter of an unknown origin.May 1, 1993 · N2257U · Substantial damage NTSB CHI93LA154Accident · No injuriesLimited investigationFinal reportCessna 150D · Lake Village, INThe pilot in command's inadequate preflight planning.Apr 25, 1993 · N4559U · Substantial damage NTSB CHI93FA137Accident · 2 fatalField investigationFinal reportCessna 177B · Rensselaer, INThe pilot-in-command's failure to maintain aircraft control. Factors were fog and drizzle, and the pilot-in-command's continuing VFR flight into IMC conditions.Apr 15, 1993 · N973CQ · Destroyed NTSB CHI93LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Sullivan, INThe student pilot's failure to maintain directional control.Apr 6, 1993 · N89098 · Substantial damage NTSB CHI93LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Marysville, INThe pilot's failure to use carburetor heat while flying in carburetor icing conditions.Mar 27, 1993 · N3439Z · Substantial damage NTSB CHI93LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Demotte, INThe pilot's poor planned approach to the runway.Mar 20, 1993 · N8655N · Substantial damage NTSB CHI93LA091Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Evansville, INThe partial failure of the normal brake system.Feb 18, 1993 · N3733B · Substantial damage NTSB CHI93LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lafayette, INThe pilot-in-command's decision to initiate flight into known icing conditions which resulted in an accummulation of airframe ice. The icing conditions and the pilot's disregard of the weather advisory were factors.Feb 6, 1993 · N8784W · Substantial damage NTSB CHI93FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 182P · Portage, INUndetermined.Feb 6, 1993 · N7227N · Destroyed NTSB CHI93LA073Accident · No injuriesLimited investigationFinal reportCessna 150 · Jeffersonville, INThe pilot's failure to maintain proper airspeed. The poorly planned approach was a factor.Jan 16, 1993 · N45563 · Substantial damage NTSB CHI93LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Kokomo, INFailure to maintain aircraft control, and spatial disorientation of the pilot.Dec 23, 1992 · N9206B · Substantial damage NTSB CHI93DET01Accident · No injuriesFinal reportCarlson Sparrow II · Lafontaine, INFuel starvation due to a blocked fuel line which was caused by improper gasket sealing compound.Dec 21, 1992 · N6648Y · Substantial damage NTSB CHI93LA021Accident · No injuriesLimited investigationFinal reportCessna C177B · Noblesville, INThe pilot's improper recovery from a bounced landing.Oct 22, 1992 · N35230 · Substantial damage NTSB CHI93LA003Accident · No injuriesLimited investigationFinal reportCessna 172P · Kokomo, INThe pilot's delayed remedial action.Oct 3, 1992 · N51829 · Substantial damage NTSB DCA92MA049Accident · 6 fatalClass 1 · MajorFinal reportMitsubishi MU-2B-60 · Greenwood, INThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the pilots of the MU-2 and the PA-32 from recognizing a collision hazard and taking actions to avoid the midair collision.…Sep 11, 1992 · N74FB · 2 aircraft · Destroyed NTSB CHI92LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Scotland, INThe pilot's delay in aborting a takeoff attempt after failing to attain flying speed during a takeoff ground run.Sep 9, 1992 · N67836 · Substantial damage NTSB CHI92LA269Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gary, INThe pilot's failure to land at the proper touchdown point on the runway and landing with excessive airspeed.Sep 9, 1992 · N33662 · Substantial damage NTSB CHI92FA267Accident · 1 fatalField investigationFinal reportPiper PA-61-601P · Aurora, INExceeding the design stress limits of the airplane by the pilot in command.Sep 8, 1992 · N717BB · Destroyed NTSB CHI92LA264Accident · No injuriesLimited investigationFinal reportCessna 170A · Angola, INFailure of the pilot to maintain directional control during landing rollout.Sep 3, 1992 · N9124A · Substantial damage NTSB CHI92LA261Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Wayne, INThe pilot's failure to maintain directional control during the landing roll.Aug 29, 1992 · N100SU · Substantial damage NTSB CHI92LA249Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Marshall, INThe pilot's failure to maintain control of the helicopter due to his alcoholic impairment of efficiency and judgement.Aug 21, 1992 · N203SD · Destroyed NTSB CHI92LA245Accident · No injuriesLimited investigationFinal reportCessna 182A · Colfax, INThe pilot's selection of the wrong runway and a premature lift off. Factors were uphill terrain and unfavorable (quartering/tail) wind.Aug 19, 1992 · N5197D · Substantial damage NTSB CHI92DET01Accident · Serious injuriesFinal reportFrost Briegleb/BG-12A · Lake Village, INInadvertent stall and spin with inadequate altitude for recovery.Aug 16, 1992 · N163MF · Substantial damage NTSB CHI92DEX04Accident · Minor injuriesFinal reportAlkire Pietenpol · Delphi, INSeparation of the propeller while in flight, and unsuitable terrain to effect a forced landing.Jul 31, 1992 · N2739 · Substantial damage NTSB CHI92DEX03Accident · 1 fatalFinal reportPiper PA-25-260 · Decker, INFailure of the right wing spar, improper maintenance/modification, and failure to comply with an airworthiness directive.Jul 18, 1992 · N4766Y · Destroyed NTSB CHI92DEX02Accident · No injuriesFinal reportTownsend-Snyder Rultan Varieze · Indianapolis, INFuel starvation due to improper fuel tank selection.Jul 9, 1992 · N40TS · Substantial damage NTSB CHI92LA208Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Kendallville, INImproper remedial action, the pilot's failure to maintain airspeed, and the failed tow rope.Jul 5, 1992 · N36133 · Substantial damage NTSB CHI92LA184Accident · No injuriesLimited investigationFinal reportCessna 150L · Evansville, INThe pilot's misjudgement of fuel supply.Jun 11, 1992 · N21906 · Substantial damage NTSB CHI92LA157Accident · No injuriesLimited investigationFinal reportCessna 150 · South Bend, INImproper aircraft control by the pilot.May 22, 1992 · N6349G · Substantial damage NTSB CHI92DEX01Accident · No injuriesFinal reportJames D. Bierly VARI-EZ · Jeffersonville, INA collapsed carburetor air intake duct. Factors related to the accident were soft, unsuitable terrain on which to make a forced landing.May 20, 1992 · N64SJ · Substantial damage NTSB CHI92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, INInadequate remedial action by the pilot in command when the engine lost partial power during cruise flight. Factors in the accident were the presence of carburetor icing conditions, and soft terrain in the area selected for a forced landing.Apr 18, 1992 · N46034 · Substantial damage NTSB CHI92LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe student pilot's failure to maintain directional control and his delaying the aborted landing.Mar 23, 1992 · N2959R · Substantial damage NTSB CHI92LA106Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Elkhart, INProper glidepath was not maintained and minimum descent altitude was not maintained by the pilot resulting in collision with trees. Factors relate to the accident were the pilot's lack of total experience in type of operation and over confidence in personal…Mar 8, 1992 · N105A · Substantial damage NTSB CHI92LA093Accident · No injuriesLimited investigationFinal reportCessna 182B · Auburn, INThe improper maintenance and adjustment of the carburetor by other maintenance personnel.Feb 28, 1992 · N2387G · Substantial damage NTSB CHI92LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Washington, INThe total loss of engine power due to a fatigue-fractured crankshaft.Feb 21, 1992 · N732TR · Substantial damage NTSB CHI92LA090Accident · No injuriesLimited investigationFinal reportCessna 414 · Logansport, INThe pilot's failure to maintain an adequate approach speed which resulted in an improper flare. Factors contributing to the accident were the inadequate inflight deicing of the airframe surfaces and in icing conditions encountered.Feb 13, 1992 · N4644G · Substantial damage NTSB CHI92LA073Accident · No injuriesLimited investigationFinal reportCessna 177RG · Indianapolis, INEngine loss of power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.Jan 18, 1992 · N8013G · Substantial damage