NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
  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.

NTSB CHI99LA259Accident · No injuriesLimited investigationFinal reportCessna 180 · Tower, MNfailure of the operator of the boat to maintain clearance with the floatplane.Jul 18, 1999 · N4636B · Substantial damageNTSB CHI99LA242Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bristol, WIthe pilot's failure to perform a proper recovery from the bounced landing, resulting in the airplane's nose gear striking the runway. A factor relating to the accident was the excessive airspeed maintained during the landing.Jul 18, 1999 · N2980H · Substantial damageNTSB CHI99LA236Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Wahoo, NEThe pilot's improper starting technique which resulted in the inadvertent starting of the engine, with no one in the airplane.Jul 18, 1999 · N3859H · Substantial damageNTSB ANC99LA105Accident · No injuriesLimited investigationFinal reportNix Avid Flyer · Chugiak, AKA loss of engine power for an undetermined reason.Jul 18, 1999 · UNREG · Substantial damageNTSB SEA99LA122Accident · No injuriesLimited investigationFinal reportCessna 150M · Glenns Ferry, IDThe pilot's failure to maintain directional control during the attempted takeoff. A related factor was the pilot's lack of recent experience.Jul 17, 1999 · N704AX · Substantial damageNTSB SEA99LA120Accident · 2 fatalLimited investigationFinal reportAnderson Rans S-12 · Bowmont, IDAircraft control was not maintained while maneuvering at low altitude. An inadvertent stall was a factor.Jul 17, 1999 · N9230X · DestroyedNTSB SEA99FA126Accident · 2 fatalField investigationFinal reportCessna T-337 G-P · Snoqualmie Pass, WAThe pilot's failure to maintain clearance from mountainous terrain while maneuvering below low ceilings. Factors include low ceilings and inadequate in-flight planning.Jul 17, 1999 · N98C · DestroyedNTSB NYC99MA178Accident · 3 fatalMajor investigationFinal reportPiper PA-32R-301 · Vineyard Haven, MAThe pilot's failure to maintain control of the airplane during a descent over water at night, which was a result of spatial disorientation. Factors in the accident were haze, and the dark night.Jul 17, 1999 · N9253N · DestroyedNTSB NYC99LA179Accident · No injuriesLimited investigationFinal reportAllen-Charles Barracuda · Hermon, NYThe pilot's inadequate preflight planning which resulted in a precautionary landing. A factor in this accident was the pilot's selection of unsuitable terrain for the precautionary landing.Jul 17, 1999 · N849JA · Substantial damageNTSB MIA99LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Dunedin, FLThe pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power.Jul 17, 1999 · N3030Q · Substantial damageNTSB LAX99LA254Accident · No injuriesLimited investigationFinal reportPiper PA32R-300 · Mammoth Lakes, CAThe pilot's failure to attain and maintain an adequate airspeed for the prevailing density altitude. The pilot's failure to abort the takeoff is also causal.Jul 17, 1999 · N1692H · Substantial damageNTSB IAD99LA055Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Millbrook, NYwas the pilot's inadequate compensation for winds and his failure to maintain directional control.Jul 17, 1999 · N3756E · Substantial damageNTSB FTW99TA194Accident · No injuriesFinal reportBell 47G-3B-1 · Sour Lake, TXThe pilot's failure to adequately preflight the helicopter's fuel system resulting in the total loss of engine power as a result of water contamination. Factors were the incorrect filter installed on the fueling truck and the pilot's improper touchdown…Jul 17, 1999 · N4002G · Substantial damageNTSB FTW99FA192Accident · 3 fatalField investigationFinal reportMBB BK-117-B2 · Fresno, TXthe loss of control during approach due to the corrosion of the T-T strap which resulted in fatigue cracking and subsequent separation of the strap and main rotor blade from the helicopter.Jul 17, 1999 · N110HH · DestroyedNTSB CHI99LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Butler, MOloss of engine power for undetermined reason, and the pilot's inability to maintain clearance from the fence during the forced landing. Factors relating to this accident were the rising terrain, the rough/uneven terrain, and the fence posts.Jul 17, 1999 · N9653J · Substantial damageNTSB CHI99LA235Accident · Serious injuriesLimited investigationFinal reportPiper J-3C · Maple Lake, MNThe pilot's inadequate preflight planning that resulted in exceeding the maximum gross weight of the airplane and the subsequent inadvertent aerodynamic stall.Jul 17, 1999 · N88593 · Substantial damageNTSB CHI99FA238Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Yorkville, ILthe pilot continuing into known adverse weather conditions, attempting low altitude flight, and not maintaining terrain clearance. Factors to the accident were the thunderstorm and the improper weather evaluation by the pilot following pre-departure and…Jul 17, 1999 · N5054F · DestroyedNTSB ATL99LA109Accident · 1 fatalLimited investigationFinal reportBlackburn John D. Jr. Bushby M II · Daytona Beach, FLThe pilot's failure to securely reconnect the distributor coil wire during routine maintenance. Factors were the unsuitable terrain and trees.Jul 17, 1999 · N102JB · Substantial damageNTSB SEA99LA124Accident · No injuriesLimited investigationFinal reportNavion B · Stanley, IDAn improperly planned approach and gusting wind conditions. A tailwind was a factor.Jul 16, 1999 · N5304K · Substantial damageNTSB LAX99LA252Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Taft, CAThe pilot's selection of the wrong runway in consideration of the wind conditions and his subsequent failure to maintain directional control. The pilot's decision to abort the landing attempt with inadequate runway remaining for the takeoff phase was also…Jul 16, 1999 · N46451 · Substantial damageNTSB FTW99LA191Accident · No injuriesLimited investigationFinal reportBell OH-58A · Bastrop, LAThe failure of the refueling truck's filter to separate water resulting in the water contamination in the helicopter's fuel system and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.Jul 16, 1999 · N9254R · Substantial damageNTSB DEN00LA033Accident · No injuriesLimited investigationFinal reportCessna T210M · Cedar City, UTThe pilot's failure to follow alternate landing gear extension procedures. Factors were the main landing gear failure to extend and a loss of electrical power.Jul 16, 1999 · N6029N · Substantial damageNTSB CHI99LA239Accident · No injuriesLimited investigationFinal reportCessna 411 · Troy, MIEngine explosion/fire during start for undetermined reason.Jul 16, 1999 · N660EM · Substantial damageNTSB ATL99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Kissimmee, FLThe pilot's improper flare and recovery from a bounced landing.Jul 16, 1999 · N734YU · Substantial damageNTSB ATL99LA108Accident · No injuriesLimited investigationFinal reportHiller UH12-C · Venice, FLLoss of engine power due to fuel starvation as a result of the passenger inadvertently shutting off the fuel supply.Jul 16, 1999 · N5317V · Substantial damageNTSB SEA99WA117Accident · 2 fatalForeign investigationPiper PA-32-300 · Clinton, CanadaJul 15, 1999 · N2947K · DestroyedNTSB NYC99LA177Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-300-600ER · Jamaica, NYimproper use of the flight controls by the captain trainee, and inadequate supervision by the check airman.Jul 15, 1999 · N80057 · Substantial damageNTSB NYC99LA176Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Sanford, METhe pilot's failure to maintain control of the airplaneJul 15, 1999 · N404EC · Substantial damageNTSB NYC99IA175Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Belmar, NJThe failure of the turbocharger clamp, resulting from improper welding settings during manufacture.Jul 15, 1999 · N121GP · Minor damageNTSB MIA99LA197Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLthe pilot's improper in-flight decisions allowing the glider to descend to a low altitude, resulting in a forced landing off the airport and subsequent impact with a tree.Jul 15, 1999 · N254BA · Substantial damageNTSB IAD99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Granville, NYThe pilot's not maintaining a proper glidepath during the visual approach to the runway.Jul 15, 1999 · N50079 · Substantial damageNTSB FTW99TA190Accident · Minor injuriesFinal reportHughes 269C · Houston, TXThe hard landing as a result of the flight instructor's failure to attain the proper airspeed before simulating an engine failure, which resulted in the development of a high sink rate. Factors were the night illumination and the soft ground.Jul 15, 1999 · N7491F · Substantial damageNTSB ANC99LA092Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Juneau, AKThe pilot's failure to maintain rotor rpm, and an inadequately planned approach. A factor associated with the accident was a tailwind.Jul 15, 1999 · N8926F · Substantial damageNTSB SEA99LA119Accident · No injuriesLimited investigationFinal reportCessna 185 · Renton, WAFailure of the pilot-in-command to maintain directional control after landing, resulting in a ground loop.Jul 14, 1999 · N532PC · Substantial damageNTSB SEA99LA118Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Opheim, MTThe pilot's failure to maintain an airspeed above stall speed (Vs), resulting in a stall/mush into the terrain during a course reversal at the end of an aerial application run. Factors include hilly terrain and high density altitude.Jul 14, 1999 · N4385Z · Substantial damageNTSB MIA99LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Boca Raton, FLa total loss of engine power due to a failed oil pump impeller which resulted in a forced landing and a subsequent hard landing on a golf course.Jul 14, 1999 · N56706 · Substantial damageNTSB FTW99LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Springtown, TXThe pilot's failure to maintain clearance with the trees during the initial takeoff climb. A factor was the high density altitude.Jul 14, 1999 · N44677 · Substantial damageNTSB DEN99LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe flight instructor's failure maintain aircraft control. A factor was the inadequate supervision by the flight instructor.Jul 14, 1999 · N5396D · Substantial damageNTSB CHI99LA237Accident · No injuriesLimited investigationFinal reportCessna 172L · Montezuma, IAthe pilot inadvertently landed on the wrong runway and exceeded the proper touchdown point on the runway. Factors associated with the accident were the gusty tailwind, the fence, and the ditch.Jul 14, 1999 · N19752 · Substantial damageNTSB ATL99LA107Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Camden, ALThe failure of the cyclic control rod due to an overstress separation resulting from a material defect (inadequate quality of material) by the manufacturer.Jul 14, 1999 · N9086T · Substantial damageNTSB LAX99MA251Accident · 2 fatalClass 1 · MajorFinal reportSchempp-Hirth Nimbus 4DM · Minden, NVThe pilot's excessive use of the elevator control during recovery from an inadvertently entered spin and/or spiral dive during which the glider exceeded the maximum permissible speed, which resulted in the overload failure of the wings at loadings beyond the…Jul 13, 1999 · N807BB · DestroyedNTSB FTW99LA188Accident · No injuriesLimited investigationFinal reportBeech C35 · Jonesboro, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were the prevailing tailwind, and the airplane's over gross weight condition.Jul 13, 1999 · N5BH · Substantial damageNTSB CHI99TA232Accident · No injuriesFinal reportHughes OH-6A · Chesterfield, MOthe pilot-in-command's improper autorotational landing.Jul 13, 1999 · N911EP · Substantial damageNTSB CHI99LA241Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Aitkin, MNthe right spring in the tailwheel assembly's separation. Factors were the fatigue in the landing gear, the maintenance personnel not identifying the fatigue during the annual inspection, and the right main gear's separation.Jul 13, 1999 · N96884 · Substantial damageNTSB CHI99LA234Accident · Serious injuriesLimited investigationFinal reportGrimm SEA Hawker · Princeton, MNThe erratic aileron control response for undetermined reasons. A factor was the tree.Jul 13, 1999 · N188AK · DestroyedNTSB CHI99LA233Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Mcville, NDthe pilot not attaining a proper climb rate. Factors were the stall/mush and the ditch.Jul 13, 1999 · N4590Y · DestroyedNTSB ATL99LA106Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Panther Burn, MSThe pilot's failure to maintain clearance that resulted in the in-flight collision with trees. A factor was his diverted attention following the failure of the DGPS.Jul 13, 1999 · N731VR · Substantial damageNTSB SEA99LA131Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Snohomish, WABrake system failure due to the presence of air bubbles in the hydraulic fluid.Jul 12, 1999 · N65PR · Substantial damageNTSB SEA99LA115Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Paul, IDThe pilot's failure to attain adequate airspeed during takeoff and initial climb, resulting in stall/mush and inability of the aircraft to sustain level flight. Factors included high density altitude, a tailwind, an uphill takeoff surface, and crops in the…Jul 12, 1999 · N8005C · Substantial damageNTSB SEA99LA114Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Shelley, IDThe pilot-in-command's failure to maintain adequate clearance with obstacles. A contributing factor were the trees.Jul 12, 1999 · N90807 · Destroyed