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 NYC96LA111Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Bloomingburg, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall spin and collision with trees.May 19, 1996 · N65847 · Minor damageNTSB LAX96LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAthe student pilot's failure to maintain directional control of the aircraft during an aborted takeoff.May 19, 1996 · N49438 · Substantial damageNTSB LAX96LA201Accident · No injuriesLimited investigationFinal reportBoeing-Brown E75NL · Columbia, CAthe pilot's failure to maintain directional control during the landing rollout.May 19, 1996 · N5862V · Substantial damageNTSB LAX96IA199Incident · No injuriesIncident investigationFinal reportBoeing 747-273C · Los Angeles, CAthe operator's failure to adopt a manufacturer's stipulated ultrasonic inspection procedure, which led to the in-flight separation of the wing panel.May 19, 1996 · N470EV · Minor damageNTSB LAX96FA200Accident · 1 fatalField investigationFinal reportCessna 414 · Kernville, CAVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude/clearance from rising/mountainous terrain. Factors relating to the accident were: the terrain and weather conditions.May 19, 1996 · N111AH · DestroyedNTSB IAD96LA093Accident · No injuriesLimited investigationFinal reportCessna 177RG · Westminster, MDThe pilot-in-command's failure to maintain control of the airplane during landing. A factor in this accident was the CFI-rated pilot/passenger's inattention.May 19, 1996 · N35082 · Substantial damageNTSB FTW96LA223Accident · No injuriesLimited investigationFinal reportCessna 170A · Wharton, TXfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in an inadvertent ground swerve.May 19, 1996 · N9131A · Substantial damageNTSB CHI96LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Maryville, MOthe pilot's selection of an unsuitable area to taxi off the narrow runway in order to turn around. The proximity of the ditch was a related factor.May 19, 1996 · N8943D · Substantial damageNTSB NYC96LA109Accident · Minor injuriesLimited investigationFinal reportMcCall WATCHA-MCCALL-IT · Steamburg, NYthe pilot/owner's failure to ensure adequate maintenance/inspection of the airplane; and a loose fuel line fitting, which resulted in a subsequent fuel leak, fuel starvation, and loss of engine power. Factors relating to the accident were: the pilot's…May 18, 1996 · N111MC · Substantial damageNTSB LAX96LA198Accident · No injuriesLimited investigationFinal reportBeech 58 · Los Angeles, CAan interruption of fuel flow to the right engine for undetermined nonmechanical reasons. A contributing factor was the pilot's failure to keep the right engine's propeller feathered which reduced the airplane single engine performance capabilities.May 18, 1996 · N58KD · Substantial damageNTSB LAX96LA197Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sylmar, CAfuel exhaustion due to the inexperienced student pilot's inadequately performed preflight inspection and her failure to refuel prior to takeoff.May 18, 1996 · N69180 · DestroyedNTSB IAD96LA081Accident · No injuriesLimited investigationFinal reportCessna 205A · Sommerville, VAthe loss of engine power for undetermined reasons during banner towing operations.May 18, 1996 · N5261G · Substantial damageNTSB FTW96LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Griffithville, ARloss of engine oil (leak) for an undetermined reason, which resulted in oil starvation and a loss of engine power; and failure of the pilot to maintain airspeed during the emergency descent/landing phase, which resulted in an inadvertent stall and subsequent…May 18, 1996 · N4424S · DestroyedNTSB FTW96LA218Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-160 · Belcher, LAThe pilot's failure to maintain aircraft control in flight. A factor was the gusty wind.May 18, 1996 · N35TX · Substantial damageNTSB CHI96LA166Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgregor, MNthe nose gear collapsed when it hit a soft spot in the runway.May 18, 1996 · N3750V · Substantial damageNTSB CHI96LA165Accident · Serious injuriesLimited investigationFinal reportAS+ AC 4 · Hartford, WIlack of airspeed control by the pilot, while maneuvering.May 18, 1996 · N29HS · Substantial damageNTSB CHI96LA164Accident · No injuriesLimited investigationFinal reportSchlitter Rans S6ES Coyote II · Hays, KSfailure of the pilot to maintain control of the airplane, when it settled back to the runway after lift-off. A factor relating to the accident was: premature raising of the flaps after lift-off.May 18, 1996 · N4307N · Substantial damageNTSB CHI96LA163Accident · No injuriesLimited investigationFinal reportJohnson Avid Flyer · Rockford, MIengine overtemperature which occurred for an undetermined reason. A factor was the excessive descent rate.May 18, 1996 · N4274A · Substantial damageNTSB LAX96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Kernville, CAthe pilot's inadequate compensation for the downdraft condition and subsequent failure to maintain a proper rate of descent.May 17, 1996 · N21312 · Substantial damageNTSB CHI96TA160Accident · No injuriesFinal reportCessna 182 · Jacksonville, ILthe pilot's improper compensation for the crosswind condition. A factor in the accident was the crosswind conditions which existed.May 17, 1996 · N661SP · Substantial damageNTSB CHI96LA162Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Fargo, NDthe flight crew did not comply with the gear down and lock checklist. The factors were a jammed nose gear and inattentive preflight planning/preparations by the pilot-in-command.May 17, 1996 · N229AM · Substantial damageNTSB ANC96LA073Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cold Bay, AKthe pilot's excessive taxi speed. Factors associated with the accident were: the pilot's improper preflight inspection of the airplane, and the entanglement of the left main landing gear brake and axle with wire.May 17, 1996 · N4319Z · Substantial damageNTSB MIA96LA141Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tallahassee, FLthe pilot's mismanagement of fuel, by failing to reposition the fuel selector to the left tank after fuel was used from the right tank, which resulted in fuel starvation, loss of engine power, and a forced landing. A factor relating to the accident was: the…May 16, 1996 · N9239B · Substantial damageNTSB FTW96TA222Accident · No injuriesFinal reportMcDonnell Douglas MD-520N · Bethany, OKThe main rotor blades' contact with the tail boom due to gusting winds during rotor deceleration.May 16, 1996 · N520DD · Substantial damageNTSB FTW96LA217Accident · No injuriesLimited investigationFinal reportCessna 182J · Jacksonville, TXthe pilot's inadequate compensation for the wind conditions. A factor was the gusting wind conditions.May 16, 1996 · N3160F · Substantial damageNTSB FTW96LA215Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · Houston, TXfailure of the pilot to obtain/maintain proper airspeed and flap setting for single engine flight. A factor relating to the accident was: Loss of power in the left engine for an undetermined reason.May 16, 1996 · N40AM · Substantial damageNTSB FTW96FA216Accident · 2 fatalField investigationFinal reportNanchang CJ-6A · Shreveport, LAa loss of engine power due to failure of the pressure carburetor diaphragm which led to restricted fuel flow through the carburetor and eventual fuel starvation. Factors contributing to the accident were the unsuitable terrain and tall trees which resulted in…May 16, 1996 · N24AD · DestroyedNTSB ANC96FA072Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas MD-11-F · Anchorage, AKthe pilot's improper in-flight planning/decision, which allowed the airplane (MD-11) to encounter wake turbulence from a larger/heavy jet airplane (Boeing 747), while on a short final approach for landing on a close-by/parallel runway with a staggered…May 16, 1996 · N614FE · Substantial damageNTSB SEA96FA094Accident · 2 fatalField investigationFinal reportCessna 320A · Provo, UTA fuel leak most probably ignited by hot exhaust gases from the leaking right engine manifold exhaust system, the decision by the pilots to operate the aircraft with knowledge of the fuel leak, and the pilot-in-command's failure to maintain adequate clearance…May 15, 1996 · N600JR · DestroyedNTSB MIA96WA140Accident · 2 fatalForeign investigationBeech 200 · Treasure Cay, BahamasMay 15, 1996 · N1865D · DestroyedNTSB FTW96LA214Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Akron, COthe pilot's failure to maintain directional control.May 15, 1996 · N9194E · Substantial damageNTSB NYC96LA105Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Vineland, NJfailure of the number 8 cylinder, which resulted in loss of engine power, a forced landing in soft terrain, and subsequent nose over of the airplane.May 14, 1996 · N6620Q · Substantial damageNTSB MIA96LA145Accident · No injuriesLimited investigationFinal reportCessna 172K · Englewood, FLFailure of the pilot-in-command to maintain visual lookout while taxiing to takeoff resulting in an on-ground collision with a tree.May 14, 1996 · N7284G · Substantial damageNTSB MIA96LA139Accident · Serious injuriesLimited investigationFinal reportEzekiel Velocity 173 · Pembroke Pines, FLloss of engine power for undetermined reason(s), resulting in a forced landing, and impact with a private residence and the ground.May 14, 1996 · N28KJ · DestroyedNTSB IAD96LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Roanoke, VAthe student pilot's failure to maintain adequate control of the aircraft during the touch and go landing. Related factors were the crosswind condition and the student pilot's lack of experience.May 14, 1996 · N67557 · Substantial damageNTSB IAD96LA077Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Hellam, PAthe pilot's loss of directional control during aerial application for undetermined reasons.May 14, 1996 · N90467 · Substantial damageNTSB FTW96WA220Accident · Minor injuriesForeign investigationDouglas DC9-14 · Tampico, MexicoMay 14, 1996 · XASNR · Substantial damageNTSB FTW96LA213Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Calhan, COthe pilot's failure to maintain directional control during landing. A factor was a gusting cross-wind.May 14, 1996 · N1690B · Substantial damageNTSB FTW96LA212Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Ft. Lupton, COthe pasenger's failure to follow the instructions given by the pilot during a briefing.May 14, 1996 · N2577G · No damageNTSB ANC96LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKthe pilot's improper planning/decision, which resulted in his failure (or inability) to maintain clearance from trees after encountering gusty crosswind conditions. The wind condition and close proximity of trees were related factors.May 14, 1996 · N5760D · Substantial damageNTSB SEA96LA093Accident · Serious injuriesLimited investigationFinal reportCrescenzi Kitfox · Terrebonne, ORThe pilot's inadequate compensation for wind conditions and failure to maintain altitude/clearance above terrain, while maneuvering to land. The unfavorable wind was a related factor.May 13, 1996 · N2094J · Substantial damageNTSB IAD96LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · Findlay, OHthe student pilot's misjudged flare during landing.May 13, 1996 · N73664 · Substantial damageNTSB CHI96LA159Accident · No injuriesLimited investigationFinal reportCessna 140 · Brooklyn, MIthe pilot's improper use of brakes during the landing. Factors relating to the accident were: the pilot's improper flare and improper recovery from a bounced landing, and the soft runway condition.May 13, 1996 · N89207 · Substantial damageNTSB CHI96LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILthe pilot not flying a proper glidepath for the displaced runway threshold.May 13, 1996 · N738CS · Substantial damageNTSB CHI96IA157Incident · Minor injuriesIncident investigationFinal reportBoeing 727-290 · Indianapolis, INthe failure of the captain and flight engineer to utilize a checklist to troubleshoot a pressurization system problem, and the flight engineer's improper control of the pressurization system which resulted in an inadvertent opening of the outflow valve and…May 13, 1996 · N775AT · No damageNTSB MIA96LA156Accident · No injuriesLimited investigationFinal reportMarcellus Star Fire · Umatilla, FLThe pilot's improper use of brakes on landing roll out resulting in a nose over.May 12, 1996 · N2498 · Substantial damageNTSB LAX96LA195Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Adelanto, CAfuel exhaustion as a result of an improper preflight inspection and operating with a known malfunctioning fuel gauge.May 12, 1996 · N6844Z · Substantial damageNTSB LAX96LA193Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Compton, CAThe pilot of the other aircraft's failure to see and avoid N6WR. A factor in the accident was the narrow, confined nature of the taxiway, which restricted the Stinson pilot's ability to perform clearing turns while taxiing.May 12, 1996 · N235DE · 2 aircraft · Minor damageNTSB IAD96LA075Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Providence, KYthe pilot's failure to maintain directional control of the airplane during the landing roll. Related factors are the crosswind weather condition, the pilot's inadequate compensation for wind conditions, and the intermittent binding of the left brake.May 12, 1996 · N58LE · Substantial damageNTSB CHI96LA158Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Springfield, MOa total loss of power due to the pilot's inadequate preflight planning and preparation and subsequent fuel exhaustion. A factor was the pilot's lack of experience in the airplane.May 12, 1996 · N6668V · Substantial damage