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.
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
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 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.NTSB LAX96LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAthe student pilot's failure to maintain directional control of the aircraft during an aborted takeoff.NTSB LAX96LA201Accident · No injuriesLimited investigationFinal reportBoeing-Brown E75NL · Columbia, CAthe pilot's failure to maintain directional control during the landing rollout.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB IAD96LA081Accident · No injuriesLimited investigationFinal reportCessna 205A · Sommerville, VAthe loss of engine power for undetermined reasons during banner towing operations.NTSB 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…NTSB 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.NTSB CHI96LA166Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgregor, MNthe nose gear collapsed when it hit a soft spot in the runway.NTSB CHI96LA165Accident · Serious injuriesLimited investigationFinal reportAS+ AC 4 · Hartford, WIlack of airspeed control by the pilot, while maneuvering.NTSB 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.NTSB CHI96LA163Accident · No injuriesLimited investigationFinal reportJohnson Avid Flyer · Rockford, MIengine overtemperature which occurred for an undetermined reason. A factor was the excessive descent rate.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB FTW96TA222Accident · No injuriesFinal reportMcDonnell Douglas MD-520N · Bethany, OKThe main rotor blades' contact with the tail boom due to gusting winds during rotor deceleration.NTSB FTW96LA217Accident · No injuriesLimited investigationFinal reportCessna 182J · Jacksonville, TXthe pilot's inadequate compensation for the wind conditions. A factor was the gusting wind conditions.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB MIA96WA140Accident · 2 fatalForeign investigationBeech 200 · Treasure Cay, BahamasNTSB FTW96LA214Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Akron, COthe pilot's failure to maintain directional control.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB IAD96LA077Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Hellam, PAthe pilot's loss of directional control during aerial application for undetermined reasons.NTSB FTW96WA220Accident · Minor injuriesForeign investigationDouglas DC9-14 · Tampico, MexicoNTSB FTW96LA213Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Calhan, COthe pilot's failure to maintain directional control during landing. A factor was a gusting cross-wind.NTSB 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.NTSB 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.NTSB 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.NTSB IAD96LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · Findlay, OHthe student pilot's misjudged flare during landing.NTSB 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.NTSB CHI96LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILthe pilot not flying a proper glidepath for the displaced runway threshold.NTSB 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…NTSB MIA96LA156Accident · No injuriesLimited investigationFinal reportMarcellus Star Fire · Umatilla, FLThe pilot's improper use of brakes on landing roll out resulting in a nose over.NTSB 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.NTSB 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.NTSB 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.NTSB 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.