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 SEA99LA035Accident · No injuriesLimited investigationFinal reportCessna 150L · Hillsboro, ORThe pilot's failure to maintain directional control of the aircraft. A related factor was the crosswind condition.Feb 20, 1999 · N16058 · Substantial damageNTSB LAX99LA107Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Yuma, AZThe pilot's failure to maintain an adequate clearance from the power lines during an aerial application flight. A factor in the accident was the dark night lighting conditions.Feb 20, 1999 · N2014U · DestroyedNTSB LAX99FA106Accident · Minor injuriesField investigationFinal reportCessna 172N · El Monte, CAAn in-flight fuel fire in the left forward doorpost due to an electrical arc from an adjacent map light switch puncturing a main fuel feed line. The manufacturer's inadequate design in routing the fuel line in close proximity to electrical arc sources in the…Feb 20, 1999 · N5174D · DestroyedNTSB FTW99LA084Accident · Minor injuriesLimited investigationFinal reportBeech BE-76 · Mesquite, TXThe flight instructor's inadequate supervision of the multi-engine rated instrument student during a simulated single engine landing, resulting in loss of control of the airplane. Factors were the dark night light condition, the flight instructor's inadequate…Feb 20, 1999 · N3819D · Substantial damageNTSB CHI99IA096Incident · No injuriesIncident investigationFinal reportCessna T210R · Tinley Park, ILthe improper installation of the pressure oil line 'B' nut by maintenance personnel. Contributing to the incident were the loose pressure oil line 'B' nut and separation of the propeller from the aircraft.Feb 20, 1999 · N7687U · Minor damageNTSB LAX99TA105Accident · No injuriesFinal reportChristen Industries A-1 · Battle Mountain, NVFailure of the pilot to maintain clearance from terrain. A factor was the dust devil encountered by the airplane.Feb 19, 1999 · N2UJ · Substantial damageNTSB LAX99LA103Accident · No injuriesLimited investigationFinal reportZivko Aeronautics Edge 540 · Livermore, CAThe manufacturer's inadequate quality control procedures, which allowed an improperly manufactured crankshaft to be shipped, resulting in the separation of one counterweight from the crankshaft lug and the subsequent catastrophic internal failure of the…Feb 19, 1999 · N9ND · Substantial damageNTSB LAX99FA104Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Coalinga, CAthe pilot's inadvertant visual flight into instrument meteorological conditions.Feb 19, 1999 · N125TW · DestroyedNTSB MIA99LA088Accident · No injuriesLimited investigationFinal reportBeech K35 · Gulfport, MSA loss of engine power due to fuel starvation caused by an obstruction in the fuel vent system while maneuvering in IMC conditions, and the subsequent ditching into the Gulf of Mexico.Feb 18, 1999 · N15FF · Substantial damageNTSB LAX99LA094Accident · No injuriesLimited investigationFinal reportBeech F33 · Prescott, AZA total loss of engine power for undetermined reasons.Feb 18, 1999 · N8253C · Substantial damageNTSB CHI99LA098Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Grand Rapids, MNthe pilot's inadequate visual lookout. A factor to the accident was the unmarked transmission wire.Feb 18, 1999 · N57468 · Substantial damageNTSB CHI99LA093Accident · No injuriesLimited investigationFinal reportMitsubishi 300 · Columbus, NEthe pilot-in-command failed to attain the proper touchdown point during the landing. Factors associated with the accident were the rough, snow covered terrain encountered off the end of the runway, and the low ceiling at the time of the landing.Feb 18, 1999 · N110DS · Substantial damageNTSB MIA99WA087Accident · No injuriesForeign investigationDouglas DC-3C · Nassau, BahamasFeb 17, 1999 · N15MA · Substantial damageNTSB FTW99LA083Accident · No injuriesLimited investigationFinal reportRobinson R22-B2 · Freer, TXThe passenger's inadvertent interference with the cyclic control which consequently restricted the control's movement.Feb 17, 1999 · N971SL · Substantial damageNTSB NYC99IA062Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-231 · Columbus, OHa failure of the external o-rings in the nose landing gear steering module.Feb 16, 1999 · N628AW · Minor damageNTSB LAX99FA101Accident · No injuriesField investigationFinal reportGrumman G-1159 · Van Nuys, CAThe pilot performed inadequate in flight planning and decided to continue the approach and landing with excessive airspeed. The pilot failed to follow company directives, which required a go around under the encountered flight conditions. This led to a long…Feb 16, 1999 · N711TE · Substantial damageNTSB DEN99LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Colorado Sprngs, COThe pilot's failure to maintain directional control of the aircraft during landing touchdown. A factor was the sign.Feb 16, 1999 · N8804J · Substantial damageNTSB DEN99LA040Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Baggs, WYA hard landing resulting from rotor rpm decay. Factors were the improper replacement of the turbine by company maintenance personnel resulting in the PC line nut becoming loose, and the pilot operating outside the normal height/velocity curve.Feb 16, 1999 · CGDCM · Substantial damageNTSB DEN99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · West Jordan, UTThe pilot's failure to maintain directional control of the aircraft. Factors were his lack of recent flight experience, and his lack of experience in the make and model of aircraft.Feb 16, 1999 · N734BE · Substantial damageNTSB ATL99FA048Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Cartersville, GAIn flight collision with terrain for undetermined reasons.Feb 16, 1999 · N21724 · DestroyedNTSB SEA99LA033Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Seattle, WAThe dual student's improper touchdown while drifting during a practice autorotation. Contributing to the accident was the flight instructor (CFI) inadequate remedial action.Feb 15, 1999 · N8362Q · Substantial damageNTSB LAX99LA133Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Prescott, AZThe pilot's inadequate compensation for the crosswind condition, which led to a loss of directional control and an inadvertent ground loop.Feb 15, 1999 · N2077U · Substantial damageNTSB LAX99LA097Accident · No injuriesLimited investigationFinal reportCessna 414 · Phoenix, AZThe overload failure of the left main gear locking mechanism due to improper system rigging by maintenance personnel.Feb 15, 1999 · N1557T · Substantial damageNTSB CHI99LA092Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lawrenceville, ILthe fatigue fracture of the landing gear actuator.Feb 15, 1999 · N9506D · Substantial damageNTSB MIA99LA084Accident · No injuriesLimited investigationFinal reportCessna 172K · Marathon, FLThe pilot's improper use of elevator control while landing in gusty winds resulting in the aircraft nosing down and the propeller and wing contacting the runway.Feb 14, 1999 · N75RR · Substantial damageNTSB LAX99LA099Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Ord, CAFuel exhaustion due to the pilot's becoming lost and disoriented during multiple attempts at completing an ILS approach.Feb 14, 1999 · N7374D · Substantial damageNTSB IAD99LA073Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Limington, MEPilot's failure to maintain directional control during the landing rollout.Feb 14, 1999 · N10730 · Substantial damageNTSB FTW99LA082Accident · No injuriesLimited investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain an adequate approach airspeed which resulted in a excessive descent rate and hard landing and the pilot's failure to recover from a bounced landing. A factor was the pilot's lack of total experience.Feb 14, 1999 · N6405K · Substantial damageNTSB SEA99LA034Accident · No injuriesLimited investigationFinal reportCessna 182A · Conner, MTThe pilots delayed remedial action during an aborted landing. Factors include a slush-covered runway.Feb 13, 1999 · N3753D · Substantial damageNTSB MIA99LA083Accident · No injuriesLimited investigationFinal reportBeech A24R · Philadelphia, MSThe failure of the pilot to ensure the aircraft tie down ropes were free from the aircraft prior to taxiing. This resulted in the aircraft turning uncontrolled when taxi was initiated due to a partially tied left wing, the pilot loosing control of the…Feb 13, 1999 · N24624 · Substantial damageNTSB LAX99LA098Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Boulder City, NVThe failure of the pilot-in-command to properly position the floatplane landing gear for a water landing and failure to verify the landing gear position resulting in an inadvertent wheels down landing on water.Feb 13, 1999 · N747CL · Substantial damageNTSB FTW99LA081Accident · No injuriesLimited investigationFinal reportCessna 188 · Alexandria, LAThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in an inadvertent ground loop.Feb 13, 1999 · N8295G · Substantial damageNTSB FTW99LA080Accident · No injuriesLimited investigationFinal reportEurocopter BK 117 B-1 · Hockley, TXThe pilot's failure to maintain clearance with the power lines. A factor was the sunglare reducing the pilot's visibility.Feb 13, 1999 · N220HH · Substantial damageNTSB NYC99LA059Accident · Serious injuriesLimited investigationFinal reportAerospatiale 355 · Toledo, OHThe pilot's decision to continue the flight which resulted in inadvertent flight into IMC, and the subsequent spatial disorientation and loss of control. A factor in the accident was the inaccuracy of the weather forecast.Feb 12, 1999 · N355MF · DestroyedNTSB NYC99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Duanesburg, NYThe instructor pilot's improper use of carburetor heat which resulted in carburetor ice, and a loss of engine power. A factor in the accident was the instructor pilot's failure to initiate the simulated engine failure from a point where a successful forced…Feb 12, 1999 · N89097 · Substantial damageNTSB MIA99WA082Accident · No injuriesForeign investigationCessna 172M · Rum Cay, BahamasFeb 12, 1999 · N61745 · Substantial damageNTSB MIA99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 210G · Lake Placid, FLa total loss of engine power due to an in-flight separation of the crankshaft, caused by a fatigue crack that originated from the aft fillet radius of the No. 2 main journal, resulting in a forced landing in a field and impact with a tree.Feb 12, 1999 · N5874F · Substantial damageNTSB LAX99LA095Accident · No injuriesLimited investigationFinal reportBeech 95 · Henderson, NVa loss of power in one engine due to the student pilot inadvertently selecting the off position on one fuel selector valve while accomplishing the prelanding checklist. The instructor's inadequate supervision of the flight was also causal.Feb 12, 1999 · N1176 · Substantial damageNTSB LAX99FA096Accident · 1 fatalField investigationFinal reportBeech C99 · Bishop, CAthe pilot's failure to follow procedures and directives and his failure to maintain clearance from mountainous terrain.Feb 12, 1999 · N205RA · DestroyedNTSB DEN99IA038Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200A · Aspen, COThe inadequate maintenance overhaul of the number four turbine disc by the manufacturer. A factor was the turbine blade's failure due to high cycle fatigue fracture.Feb 12, 1999 · N608AW · Minor damageNTSB ANC99FA028Accident · Serious injuriesField investigationFinal reportBeech 1900C · Saint Mary'S, AKThe pilot's descent below the minimum descent altitude on the instrument approach. Factors were pilot fatigue resulting from the pilot's rest period being interrupted by scheduling discussions and the night weather conditions of low ceilings and whiteout.Feb 12, 1999 · N31240 · Substantial damageNTSB NYC99FA060Accident · 1 fatalField investigationFinal reportCessna 170A · Leominster, MAThe pilot's failure to maintain the proper altitude during the approach.Feb 11, 1999 · N1460D · Substantial damageNTSB MIA99LA079Accident · Minor injuriesLimited investigationFinal reportWolf Seawind 3000 · Bradenton, FLTotal loss of engine power due to a burned piston for undetermined reasons resulting in a forced landing to unsuitable terrain and the subsequent crash landing onto a golf course.Feb 11, 1999 · N76SW · Substantial damageNTSB MIA99LA077Accident · Minor injuriesLimited investigationFinal reportLee S. Harvard LONG-EZ · Spring Hill, FLThe failure of the pilot to insure the canopy was closed prior to takeoff resulting in an aborted takeoff, overheating of the brakes, and a roll over when the aircraft was turned off the runway into the grass in an attempt to stop.Feb 11, 1999 · N96LH · Substantial damageNTSB LAX99LA093Accident · Serious injuriesLimited investigationFinal reportAerostar RX-9 · Peoria, AZThe pilot's attempted flight in an area of forecasted high winds and his inadequate compensation for those wind conditions once encountered.Feb 11, 1999 · N91067 · Substantial damageNTSB NYC99LA057Accident · No injuriesLimited investigationFinal reportCessna 310R · Monticello, NYThe pilot in command's loss of directional control.Feb 10, 1999 · N87464 · Substantial damageNTSB MIA99LA080Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, MSThe pilot's improper recovery from a bounced landing, resulting in a blown nose tire, loss of directional control, and subsequent collision with terrain.Feb 10, 1999 · N6089K · Substantial damageNTSB MIA99LA078Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Sanford, FLthe pilot misjudged the flare resulting in a hard landing and damage to the airplane.Feb 10, 1999 · N39531 · Substantial damageNTSB IAD99LA030Accident · Minor injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Kutztown, PAwas the in-flight encounter with thermal sink over unsuitable terrain for landing.Feb 10, 1999 · N210C · Substantial damageNTSB NYC99LA055Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Herminie, PAThe partial loss of engine power for undetermined reasons.Feb 9, 1999 · N5070J · Substantial damage