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 NYC07LA036Accident · No injuriesLimited investigationFinal reportCessna T210N · Caldwell, NJThe private pilot's failure to maintain adequate altitude/clearance, and the flight instructor's failure to take remedial action. Contributing to the accident was the night light conditions.NTSB NYC07LA033Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Bardstown, KYThe loss of engine power for undetermined reasons.NTSB NYC07CA035Accident · Minor injuriesData collectionFinal reportBaggett RV6A · Nokesville, VAThe pilot's inadequate compenstation for a crosswind while landing, which resulted in a loss of directional control.NTSB NYC07CA034Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Benton, KYThe pilot's improper decision to fly between the trees during his approach to the runway.NTSB MIA07CA021Accident · Minor injuriesData collectionFinal reportRobinson R22 · Lakeland, FLThe flight instructor's failure to maintain control of the helicopter during takeoff resulting in a roll over.NTSB MIA07CA020Accident · No injuriesData collectionFinal reportLiberty Aerospace XL-2 · Melbourne, FLThe pilot's (Dual Student) failure to relinquish control of the airplane when instructed by the certified flight instructor resulting in airspeed not being maintained and an inadvertent stall.NTSB LAX07CA043Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Santa Clarita, CAthe student pilot's inadequate compensation for wind conditions and the instructor's failure to arrest the descent, which resulted in a dynamic rollover. Also causal was the inadequate supervision by the instructor. A factor in the accident was the wind shift…NTSB LAX07CA042Accident · No injuriesData collectionFinal reportPippert Zenith CH-701 · Yerington, NVthe pilot's inadequate compensation for the wind conditions and failure to maintain both directional and pitch control.NTSB ATL07CA023Accident · No injuriesData collectionFinal reportHudspeth Shawn D Challenger II · Bessemer, ALThe pilot's failure to maintain control of the airplane during an approach for landing. A factor in the accident was gusting winds.NTSB ATL07CA020Accident · No injuriesData collectionFinal reportCessna 190 · Chattanooga, TNThe pilot's failure to maintain directional control on takeoff resulting in a collapse of the left main landing gear when the airplane swerved. A factor in the accident was wake turbulence from a landing airplane.NTSB LAX07LA040Accident · No injuriesLimited investigationFinal reportStinson 108-1 · San Jose, CAPartial loss of engine power due to a seized exhaust valve during cruise flight. Rough terrain at the forced landing site was a contributing factor.NTSB LAX07LA039Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Diego, CAAn undetermined total electrical failure. The pilot's failure to extend the landing gear to the down and locked position was a factor.NTSB CHI07FA026Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Wellington, ILSpatial disorientation experienced by the pilot while attempting to visually locate traffic during cruise flight, which resulted in a loss of aircraft control. Contributing factors were the inadvertent overload failure of the wing spar and stabilator, and the…NTSB MIA07CA019Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna, FLThe student pilot's improper recovery from a bounced landing.NTSB LAX07CA038Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Grand Canyon, AZThe pilot's inadequate compensation for the crosswind condition during the landinf roll which resulted in a loss of control and an on ground collision with a berm.and failure to maintain directional control.NTSB DEN07CA026Accident · Serious injuriesData collectionFinal reportLiberty Aerospace Liberty XL-2 · Albuquerque, NMthe student pilot's improper flare and subsequent improper recovery from a bounced landing resulting in an inadvertent loss of control.NTSB SEA07LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Billings, MTThe flight instructor's inadequate remedial action to maintain directional control, which resulted in a ground loop/swerve during takeoff roll. A factor was the failure of the pilot who was receiving instruction to maintain directional control.NTSB NYC07LA030Accident · No injuriesLimited investigationFinal reportStump Rotorway Exec 90 · Manchester, NHAn improperly installed oil line, which resulted in oil line fatigue failure and a subsequent loss of oil to the engine. A contributing factor was the sloping terrain at the forced landing site.NTSB MIA07TA017Accident · Minor injuriesFinal reportEurocopter AS 350 BA · Ft. Myers, FLThe pilot's failure to maintain aircraft control during engine start. Contributing to the accident was the pilot's improper advancement of the fuel control lever.NTSB MIA07CA018Accident · Serious injuriesData collectionFinal reportSargent Jonathan Varieze · Punta Gorda, FLThe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's inadequate preflight, which did not ensure the security of the canopy before flight.NTSB LAX07LA037Accident · 1 fatalLimited investigationFinal reportBeechcraft J35 · Flagstaff, AZThe pilot's inadequate in-flight planning while on approach which lead to a loss of engine power due to fuel starvation.NTSB DCA07WA011Accident · No injuriesForeign investigationBoeing B-727 · Leticia, ColombiaNTSB CHI07IA067Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Fort Wayne, INThe fatigue failure/separation of the engine mount's nose gear actuator attachment foot, and the manufacturer's inadequate engine mount/nose gear actuator attachment design.NTSB ATL07CA019Accident · Serious injuriesData collectionFinal reportHolmgreen RV-6A · Midway, GAAn on ground encounter with rough/uneven terrain during the landing roll out resulting in the collapse of the nosewheel and subsequent nose over.NTSB NYC07LA032Accident · No injuriesLimited investigationFinal reportColumbia LC41-550FG · Somerville, NJThe tug driver's inadequate lookout for landing traffic before crossing the runway.NTSB DCA07WA010Incident · No injuriesForeign investigationMcDonnell Douglas DC-10-30F · Baranquilla, ColombiaNTSB CHI07CA025Accident · No injuriesData collectionFinal reportCessna 172G · Ankeny, IAThe pilot's improper decision to land on an unlighted runway at night, and her resulting failure to attain a proper touchdown point leading to the landing over run. Contributing factors were the night (low light) condition and the ditch encountered during the…NTSB SEA07IA019Incident · No injuriesIncident investigationFinal reportCessna 172 · Seattle, WAThe instructor pilot's improper in-flight decision not to take evasive action as a heavy aircraft passed by while on an upwind parallel approach path to an adjacent runway, leading to a wake vortices encounter. Factors include a nearly direct crosswind…NTSB DEN07WA025Accident · 1 fatalForeign investigationBurton Christen Eagle II · Pfronten, GermanyNTSB SEA07LA018Accident · No injuriesLimited investigationFinal reportAviat A-1B · Fruitland, UTThe pilot's improper in-flight decision to land on snow covered terrain. Deep snow on the terrain that the pilot chose to land on was a factor in this accident.NTSB NYC07FA029Accident · Serious injuriesField investigationFinal reportRobinson R44 II · Baltimore, MDThe pilot's failure to maintain control while landing to a trailer, which resulted in a collision with terrain. A factor in the accident was the narrow trailer.NTSB LAX07CA036Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Tucson, AZThe pilot's improper use of the spoilers during the landing flare, which resulted in a hard landing, and his inadequate bounced landing recovery technique.NTSB CHI07LA024Accident · 1 fatalLimited investigationFinal reportMaule MX-7-180B · Edenville, MIThe pilot's loss of control during landing on a lake resulting in the amphibian aircraft flipping over inverted.NTSB SEA07LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, IDThe pilot's inadequate in-flight planning by failing to refuel while en route which resulted in fuel exhaustion and loss of engine power while on approach to the airport. Rough/uneven terrain was a factor.NTSB MIA07CA016Accident · No injuriesData collectionFinal reportJerald F. Huffman Rebel · Wimauma, FLThe pilot's inadvertent application of brakes during the landing flare touchdown which resulted in the airplane nosing over.NTSB LAX07FA035Accident · 3 fatalField investigationFinal reportCessna 421B · Big Bear Lake, CAFailure of the turbine wheel shaft in the left turbocharger during the takeoff initial climb for undetermined reasons, and the pilot's failure to attain and maintain safe single engine airspeed that led to a loss of control.NTSB CHI07FA022Accident · 5 fatalField investigationFinal reportCessna T303 · Mill Creek, INThe pilot became spatially disoriented and as a result failed to maintain control of the airplane. Factors associated with the accident were the instrument meteorological conditions aloft and the pilot being fatigued.NTSB CHI07CA023Accident · Minor injuriesData collectionFinal reportMooney M20J · Akron, OHThe pilot's failure to maintain sufficient airspeed during final approach resulting in an inadvertent stall. Contributing factors were the airplane's low altitude at the time of the stall and the asymmetric flap configuration.NTSB MIA07CA015Accident · Minor injuriesData collectionFinal reportBellanca BL-17-30 · Lantana, FLThe pilot's improper preflight planning/decision which resulted in total loss of engine power due to fuel exhaustion.NTSB LAX07LA032Accident · 2 fatalLimited investigationFinal reportKolb MK III · Paulden, AZfailure of the pilot to maintain an adequate airspeed that led to a stall/spin.NTSB DEN07LA024Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Melrose, NMthe in-flight failure and separation of both tail rotor blades. Contributing factors in this accident were the check pilot interferring with the controls and his failure to relinquish control to the pilot-in-command.NTSB DEN07CA023Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Fe, NMthe pilot's failure to maintain directional control during the landing roll, and his failure to maintain airspeed which resulted in a stall and hard landing.NTSB NYC07LA027Accident · 1 fatalLimited investigationFinal reportPiper PA-32R-300 · Williamsburg, VAThe pilot's improper decision to depart into adverse weather conditions. Contributing was the gusty wind conditions.NTSB LAX07LA031Accident · No injuriesLimited investigationFinal reportRyan Navion B · Riverside, CAA leak in the fuel selector valve and gascolator that resulted in fuel starvation on takeoff due to air leakage into the fuel system. A contributing factor in the accident was the inadequate annual inspection performed by other maintenance personnel.NTSB DFW07LA024Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Pocasset, OKThe "abnormally high" oil temperature indication and smoke in the cabin for undetermined reasons. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB NYC07LA026Accident · 1 fatalLimited investigationFinal reportVogel Glastar 41 · Snow Shoe, PAThe builder's improper installation of an additional alternator. Contributing to the accident were the night lighting conditions.NTSB NYC07FA025Accident · 1 fatalField investigationFinal reportCzech Aircraft Works CH 601 XL RTF · Basye, VAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB NYC07CA028Accident · Minor injuriesData collectionFinal reportPiper PA-11 · Van Hornsville, NYThe pilot's failure to maintain clearance from trees during landing.NTSB MIA07LA014Accident · No injuriesLimited investigationFinal reportCessna 150J · DeFuniak Springs, FLThe loss of engine power for undetermined reasons.NTSB MIA07LA013Accident · Minor injuriesLimited investigationFinal reportWinter J.T/Johnson Kitfox III · Southwest Ranch, FLThe owner/builder's improper maintenance/installation of the propeller which resulted in a propeller blade coming loose and separating from the hub.