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 SEA96LA092Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Bend, ORThe pilot in command's failure to adequately compensate for wind conditions during the landing. Factors contributing to the accident were a crosswind and gusty wind conditions.May 11, 1996 · N2606Z · DestroyedNTSB NYC96LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Readington, NJthe pilot's inadequate evaluation of the weather, and his misjudgment of altitude and distance from the runway. Contributing factors were the pilot's lack of recent experience and the weather.May 11, 1996 · N17957 · Substantial damageNTSB NYC96LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Marshfield, MAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a loss of control, on-ground collision with terrain, and the aircraft nosing over. The sudden windshift was a related factor.May 11, 1996 · N2528S · Substantial damageNTSB MIA96GA138Accident · 1 fatalFinal reportWsk Pzl Mielec M18A · Kinston, NCa cracked/fractured #5 cylinder and subsequent failure/jamming of the #5 exhaust valve, which resulted in a partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall and collision with the terrain. Factors…May 11, 1996 · N2065K · DestroyedNTSB LAX96LA196Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Williams, CAThe pilot's failure to maintain directional control during a rejected takeoff, and the catastrophic failure of the engine's turbine section due to an improper overhaul procedure. A factor in the accident was the close proximity of the drainage ditch to the…May 11, 1996 · N447AT · Substantial damageNTSB IAD96LA083Accident · No injuriesLimited investigationFinal reportLithuanian Factory of LAK-12 · Woodbine, MDThe pilot's decision to fly with inadequate research of forecast weather.May 11, 1996 · N112LK · Substantial damageNTSB FTW96LA211Accident · No injuriesLimited investigationFinal reportBoeing E75 · Taos, NMthe pilot's failure to maintain directional control. A factor was the dust devil.May 11, 1996 · N4787V · Substantial damageNTSB FTW96LA209Accident · No injuriesLimited investigationFinal reportCessna 150M · Springdale, ARthe flight instructor's improper (unapproved) procedure of using the mixture control to simulate an engine failure. A factor relating to the accident was: the lack of suitable terrain for a forced landing.May 11, 1996 · N704RS · Substantial damageNTSB FTW96IA210Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Dallas, TXfailure of the pilot to maintain directional control and runway alignment, during the landing roll out. Factors relating to the incident were: darkness, the adverse weather condition, the wet runway, and reduced visibility due to the inadvertent encounter…May 11, 1996 · N315SW · Minor damageNTSB FTW96FA208Accident · 1 fatalField investigationFinal reportJerrell RV-4 · Englewood, COfailure of the pilot of the RV-4, N44AZ, to comply with an ATC clearance by landing on the wrong runway, and the failure of the pilot of the SU-29, N55SU, to maintain an adequate visual lookout. Factors in the accident were: the failure of the air traffic…May 11, 1996 · N44AZ · 2 aircraft · DestroyedNTSB DCA96MA054Accident · 110 fatalClass 1 · MajorFinal reportDouglas DC-9-32 · Miami, FLwhich resulted from a fire in the airplane's class D cargo compartment that was initiated by the actuation of one or more oxygen generators being improperly carried as cargo, were (1) the failure of SabreTech to properly prepare, package, and identify…May 11, 1996 · N904VJ · DestroyedNTSB SEA96LA091Accident · No injuriesLimited investigationFinal reportLimes Challenger II · Redmond, ORthe pilot's misjudgment of distance and altitude on final approach, and his failure to maintain proper clearance from an object (fence) in his approach path. The fence was a related factor.May 10, 1996 · N52898 · Substantial damageNTSB NYC96LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Kittanning, PAthe pilot's inadequate inflight planning/decision and improper fuel management, which resulted in a precautionary landing on unsuitable terrain.May 10, 1996 · N22946 · Substantial damageNTSB IAD96LA076Accident · 2 fatalLimited investigationFinal reportCessna 150 · Welch, WVthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear obstacles. A factor was his intentional buzzing.May 10, 1996 · N6303S · DestroyedNTSB FTW96LA207Accident · Minor injuriesLimited investigationFinal reportBowers Midget Mustang M-1 · Mesquite, TXThe pilot's failure to maintain aircraft control following the separation of the propeller spinner installed by the pilot. A factor was the pilot's failure to obtain the required FAA inspection for the installation.May 10, 1996 · N9516 · DestroyedNTSB FTW96LA206Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Claude, TXthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. Soft terrain was a related factor concerning nose over in the emergency landing area.May 10, 1996 · N7426R · Substantial damageNTSB FTW96LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Iowa, LAthe pilot's selection of an unsuitable area for takeoff. The high vegetation (tall grass) was a related factor.May 10, 1996 · N6832K · Substantial damageNTSB NYC96LA102Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Olean, NYthe pilot's improper IFR procedure by not maintaining the minimum descent altitude (MDA) during the ILS localizer approach. Factors relating to the accident were: low ceiling, fog, and weather below minimums for landing.May 9, 1996 · N65792 · Substantial damageNTSB IAD96LA073Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BCS-65 · Wolfeboro, NHthe pilot's failure to maintain control and altitude of the seaplane while circling to draw attention before landing on the lake. A related factor was that the aircraft was not equipped with a radio.May 9, 1996 · N29591 · Substantial damageNTSB IAD96FA074Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Sunapee, NHthe pilot's failure to maintain control of the airplane. Factors in this accident were: the pilot's lack of currency in type and model airplane, and not following the requirement for the pilot to have a flight instructor onboard during water landings.May 9, 1996 · N5040L · DestroyedNTSB FTW96LA204Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Okmulgee, OKThe pilot's continued operation with known deficiencies in the airplane and the pilot's and maintenance personnel's failure to comply with an airworthiness directive resulting in the malfunctioning of a worn ignition switch. A factor was trees.May 9, 1996 · N202EX · Substantial damageNTSB CHI96LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lafayette, INthe flight instructor's inadequate supervision and the dual student's failure to extend the landing gear. Factors were the distraction of the flight instructor and the student's failure to use checklist procedures.May 9, 1996 · N9816C · Substantial damageNTSB FTW96LA203Accident · No injuriesLimited investigationFinal reportCessna 172K · Leadville, COthe pilot's failure to adequately compensate for the wind conditions and to maintain directional control. Factors were: the gusting cross wind and the pilot's lack of total experience in make and model of aircraft.May 8, 1996 · N79212 · Substantial damageNTSB CHI96GA154Incident · No injuriesFinal reportBeech 200 · Peoria, ILthe pilot's intentional flight into known adverse weather conditions and the lightning strike.May 8, 1996 · N961LL · Minor damageNTSB CHI96FA152Accident · Serious injuriesField investigationFinal reportCessna 340A · Waukegan, ILthe pilot's inability to maintain visual contact with the runway environment due to 'flash blindness' when he turned on the airplane's landing light, and his subsequent inability to regain control of the airplane after turning off the landing light due to his…May 8, 1996 · N225BA · Substantial damageNTSB LAX96LA192Accident · No injuriesLimited investigationFinal reportCessna 172P · Reno, NVthe pilot's failure to obtain and maintain flying speed and a proper glide path, which resulted in an inadvertent stall during a visual approach. An increased altitude illusion created by rising terrain under the final approach course was a factor.May 7, 1996 · N5394K · Substantial damageNTSB LAX96LA191Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Page, AZthe pilot's inadequate compensation for a gusty crosswind condition, and his failure to obtain and maintain an adequate airspeed during the takeoff initial climb in a high density altitude situation, which resulted in an inadvertent stall/mush. Related…May 7, 1996 · N100YJ · DestroyedNTSB IAD96LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-600 · Syracuse, NYthe pilot's failure to ensure that his hand would remain clear of the propeller, while attempting to take remedial action to secure the clam shell door. The unlatching and separation of the clam shell door from the aircraft were related factors.May 7, 1996 · N222KD · Minor damageNTSB ATL96LA085Accident · Minor injuriesLimited investigationFinal reportMerle Musson Cozy · Covington, TNThe clogged fuel strainer that resulted in an engine stoppage. A factor was the lack of a suitable landing site.May 7, 1996 · N86LM · Substantial damageNTSB ATL96FA084Accident · 3 fatalField investigationFinal reportLake 4-200 · Melbourne, FLThe pilot's failure to maintain clearance from trees while maneuvering. A factor was the tailwind condition.May 7, 1996 · N3027P · Substantial damageNTSB NYC96FA101Accident · 2 fatalField investigationFinal reportCessna P210N · Ridgefield, CTimproper planning/decision by the pilot, which led to flight into icing conditions; and his failure to use all anti-ice and deicing equipment, as specified by the airplane operator's manual for inadvertent flight into icing conditions. This resulted in loss…May 6, 1996 · N450T · DestroyedNTSB IAD96LA071Accident · No injuriesLimited investigationFinal reportBeech A36 · Hot Springs, VAthe pilot's failure to attain adequate aircraft speed during takeoff. Related factors were the density altitude and gusty wind conditions.May 6, 1996 · N12JE · Substantial damageNTSB FTW96LA202Accident · No injuriesLimited investigationFinal reportStinson 108-2 · El Paso, TXthe pilot's improper inflight planning/decision, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: the unfavorable en route wind.May 6, 1996 · N427C · Substantial damageNTSB ATL96LA086Accident · No injuriesLimited investigationFinal reportCessna 172 · Winston-Salem, NCThe pilot's improper use of the elevator in response to a bounced landing.May 6, 1996 · N97277 · Substantial damageNTSB ANC96LA070Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's failure to maintain control of the airplane during takeoff.May 6, 1996 · N3193B · DestroyedNTSB SEA96LA090Accident · Serious injuriesLimited investigationFinal reportMiller MA-5 Charger · Kennewick, WAfailure of the pilot to maintain adequate airspeed, during the initial climb after takeoff, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's lack of total and recent flight experience.May 5, 1996 · N36CM · Substantial damageNTSB SEA96LA089Accident · No injuriesLimited investigationFinal reportCessna A185E · Cascade, IDthe pilot's improper planning/decision, his failure to ensure that the airplane would maintain proper clearance from obstructions (trees), and his delay in aborting the takeoff. The soft/wet runway and tailwind were related factors.May 5, 1996 · N185MP · Substantial damageNTSB NYC96LA100Accident · No injuriesLimited investigationFinal reportCessna P206D · Harrison, NYseparation of the number one connecting rod bolt, which resulted in a total loss of engine power.May 5, 1996 · N8744Z · Substantial damageNTSB NYC96LA099Accident · No injuriesLimited investigationFinal reportElves Rotorway Exec 90 · Somerset, PAthe kit manufacturer's inadequate design of a throttle bushing, which resulted in insufficient clearance after the bushing became heated, restricted throttle movement, lack of engine response, hard landing, gear (skid) collapse, and rollover.May 5, 1996 · N162AK · Substantial damageNTSB NYC96LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Harwinton, CTthe operator's failure to eliminate water-contaminated fuel from the airplane, which resulted in the loss of engine power and collision with an obstacle during the forced landing. Also causal was an improperly maintained fuel storage facility.May 5, 1996 · N25414 · Substantial damageNTSB MIA96LA137Accident · No injuriesLimited investigationFinal reportCessna U206G · Gulf Of MexicoLoss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.May 5, 1996 · N9702Z · Substantial damageNTSB ANC96LA069Accident · No injuriesLimited investigationFinal reportGillespie Challenger 2 · Talkeetna, AKThe pilot's failure to properly use the mixture control to enrich the fuel mixture, and the seizure of the piston in the cylinder.May 5, 1996 · N1591G · Substantial damageNTSB SEA96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Harper, ORthe pilot's selection of unsuitable terrain (landing area) for a precautionary landing. A factor relating to the accident was: the pilot became ill during the flight.May 4, 1996 · N3568D · Substantial damageNTSB NYC96LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bath, PAthe pilot's improper in-flight decision and planning, and his mismanagement of the fuel supply, which resulted in fuel exhaustion and the loss of engine power. Darkness and low clouds in the emergency landing area were related factors.May 4, 1996 · N9549J · Substantial damageNTSB LAX96LA209Accident · No injuriesLimited investigationFinal reportCessna 172 · Marana, AZthe pilot's improper flare and improper recovery from a bounced landing.May 4, 1996 · N8811B · Substantial damageNTSB LAX96LA188Accident · No injuriesLimited investigationFinal reportCessna 180 · Lake Havasu Cty, AZthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control. The wind was a factor.May 4, 1996 · N4691B · Substantial damageNTSB LAX96FA189Accident · 4 fatalField investigationFinal reportCessna 310D · Los Angeles, CAfailure of the pilot to maintain aircraft control due to spatial disorientation. Factors were clouds and dark night light conditions, and the pilot's diverted attention due to a landing gear problem.May 4, 1996 · N6780T · DestroyedNTSB FTW96FA200Accident · 1 fatalField investigationFinal reportNorth American Harvard MK II · Lafayette, LAfailure of the pilot to maintain adequate airspeed and/or altitude, while performing aerobatic flight.May 4, 1996 · N2755Z · DestroyedNTSB CHI96LA151Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Big Lake, MNthe pilot's inadequate preflight of the helicopter by not having removed a tiedown strap before attempting takeoff.May 4, 1996 · N177HA · Substantial damageNTSB CHI96LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Blaine, MNthe student pilot's inadvertent encounter with the propblast from another airplane. A factor relating to the accident was: failure of the student to communicate with the pilot(s) of the other airplane before taxiing behind it.May 4, 1996 · N93844 · Substantial damage