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 SEA07LA059Accident · Minor injuriesLimited investigationFinal reportBarnhart RV-6 · Auburn, WAA loss of engine power due to the obstruction of the engine's air inlet by a fabricated neoprene seal, and inadequate maintenance by unknown maintenance personnel. A contributing factor was the lack of suitable terrain for a forced landing.NTSB MIA07IA052Incident · No injuriesIncident investigationFinal reportLiberty Aerospace XL-2 · Ormond Beach, FLThe improper manufacturing of the nose undercarriage leg by the vendor, and the inadequate surveillance of the vendor by the airplane manufacturer.NTSB DFW07LA075Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lubbock, TXThe pilot's improper landing flare. A contributing factor was the prevailing tailwind.NTSB DFW07CA079Accident · Serious injuriesData collectionFinal reportBuckeye Breeze XL · Buffalo City, ARThe pilot's failure to maintain control of the aircraft during approach. A contributing factor was the reported encounter with severe turbulence.NTSB DFW07CA074Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Granbury, TXThe pilot's misjudgment of altitude and distance while landing, which resulted in an undershoot of the runway. A contributing factor was the rising terrain on approach to the runway.NTSB DFW07CA066Accident · No injuriesData collectionFinal reportBell ARH-70 Exp. · Mansfield, TXFuel starvation due to blockage in a fuel system check valve which was the result of the improper assembly of fuel boost pump by company maintenance personnel.NTSB DCA07WA027Accident · No injuriesForeign investigationBoeing · Surabaya, IndonesiaNTSB MIA07CA051Accident · Minor injuriesData collectionFinal reportVan's RV7A · Green Cove, FLThe pilot's failure to maintain sufficient airspeed to avoid a stall during the final approach to land, resulting in an in-flight loss of control, a hard landing, and a nose over. Factors associated with the accident are an inadvertent stall, and the pilot's…NTSB LAX07CA091Accident · No injuriesData collectionFinal reportMaule M-7-235B · Prescott, AZThe pilot's inadequate preflight inspection, and his failure to maintain sufficient airspeed to avoid a stall/mush during an aborted takeoff, which resulted in a loss of control, and an in-flight collision with terrain. Factors associated with the accident…NTSB ENG07WA017Accident · No injuriesForeign investigationBell 212 · Sao Paulo,, BrazilNTSB ATL07LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-31-350 · Phenix City, ALLoss of engine power due to fuel starvation, the pilot's inadequate preflight planning, and his misunderstanding of how the fuel system operates. Contributing to the accident was the manufacturers insufficiently defined procedures for low fuel operations,…NTSB ANC07LA021Accident · No injuriesLimited investigationFinal reportCessna 402C · Cordova, AKThe failure of the right main landing gear linkage during the landing roll, which resulted in a loss of directional control and the collapse of the right main landing gear. A factor associated with the accident was the failure of company maintenance personnel…NTSB LAX07CA090Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Tucson, AZThe failure of the student pilot to maintain an adequate main rotor rpm and the instructor’s failure to maintain control of the aircraft.NTSB DFW07FA073Accident · 1 fatalField investigationFinal reportCessna 210K · Lago Vista, TXThe pilot's failure to maintain clearance from terrain. A factor was the pilot's diverted attention with a reported autopilot malfunction.NTSB DFW07FA071Accident · 1 fatalField investigationFinal reportStevens KB-2 · Oklahoma City, OKThe pilot's failure to maintain control of the gyroplane while in the traffic pattern. Contributing to the accident was the high wind with terrain induced turbulence and the absence of the gyroplane's horizontal stabilizer.NTSB DCA07MA072Accident · No injuriesClass 1 · MajorFinal reportEmbraer ERJ-170 · Cleveland, OHthe failure of the flight crew to execute a missed approach when visual cues for the runway were not distinct and identifiable. Contributing to the accident were (1) the crew's decision to descend to the ILS decision height instead of the localizer…NTSB NYC07CA067Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe pilot's failure to maintain a proper glidepath to the runway.NTSB MIA07LA050Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fountain, FLA loss of engine power due to a cracked engine exhaust muffler. Contributing to the accident were the inadequate inspection procedures of the muffler system and the routing of the "P" leads wiring for the magnetos.NTSB LAX07CA096Accident · No injuriesData collectionFinal reportPeay Quckie Q-200 · Livermore, CAThe pilot failed to maintain directional control during an aborted takeoff.NTSB LAX07CA089Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Nampa, IDthe pilot's misjudged flare and improper use of the elevator flight control.NTSB LAX07CA088Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Compton, CAThe pilot's failure to maintain directional control during landing rollout. A contributing factor was the passenger's interference with the pilot's manipulation of the controls.NTSB DFW07CA072Accident · No injuriesData collectionFinal reportAmerican Legend AL-11 · Dryden, TXThe pilot's inadequate compensation for the existing crosswind conditions and failure to maintain proper runway alignment.NTSB DCA07WA028Incident · No injuriesForeign investigationBoeing 737-400 · Alghero Fertili, ItalyNTSB CHI07FA073Accident · 4 fatalField investigationFinal reportCessna 340A · Council Bluffs, IAThe pilot's continued flight into adverse weather, and his failure to maintain altitude during the instrument approach. Contributing factors were the presence of severe icing, moderate turbulence, and low-level wind shear.NTSB DEN07WA062Accident · 1 fatalForeign investigationPiper PA-34-200T · Natal, BrazilNTSB DEN07IA069Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Denver, COFracturing of the aircraft windscreens due to impact with foreign object debris. Contributing to the event was the high, gusty surface winds.NTSB CHI07CA074Accident · No injuriesData collectionFinal reportCessna 172S · St. Louis, MOThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Factors were the gusting crosswind conditions and the snow covered ground.NTSB DFW07CA070Accident · Minor injuriesData collectionFinal reportCessna 172B · Stephenville, TXThe loss of engine power during the landing approach due to the pilot's failure to follow the appropriate procedures to preclude carburetor ice in known carburetor icing conditions.NTSB LAX07IA093Incident · No injuriesIncident investigationFinal reportColumbia LC41-550FG · Banning, CAJammed aileron flight control during cruise flight due to the presence of foreign object debris, which resulted from the manufacturer's improper processes.NTSB LAX07CA092Accident · No injuriesData collectionFinal reportCessna 172S · Lake Wells, FLthe flight instructor's inadequate compensation for the gusty crosswind conditions.NTSB NYC07RA064Accident · Serious injuriesForeign investigationBombardier CL-600-2B19 · Moscow, RussiaNTSB ANC07LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKThe partial loss of engine power for an undetermined reason during takeoff, which resulted in an aborted takeoff and collision with trees.NTSB DEN07WA060Accident · 1 fatalForeign investigationPiper PA-31T · Rieschweiler, GermanyNTSB CHI07FA069Accident · 2 fatalField investigationFinal reportEurocopter France EC120B · Gulf of MexicoThe pilot's inadequate compensation for the gusty wind conditions which resulted in his failure to maintain clearance with the structure extending from the offshore oil platform. Contributing to the accident was the gusty wind condition.NTSB ATL07CA043Accident · No injuriesData collectionFinal reportBurkhart-Grob G109 · Monticello, GAThe pilot's improper recovery from a bounced landing, which resulted in a loss of control, an in-flight collision with a hangar, and subsequent in-flight collision with the runway.NTSB NYC07CA066Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Alton, NHThe pilot's failure to maintain control of the airplane during the takeoff roll. Factors were the slick condition of the runway, and the lack of markings to denote the runway safety area.NTSB MIA07LA049Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369FF · Placida, FLThe in-flight separation of the tail rotor pitch change control rod and bellcrank during takeoff-initial climb.NTSB DFW07CA069Accident · Serious injuriesData collectionFinal reportCessna 172 · Lancaster, TXThe spectator's inadvertent contact with the turning propeller while the airplane was standing with the engine operating. A contributing factor was the dark night conditions.NTSB CHI07LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Pellston, MIThe fatigue failure of the engine cylinder which resulted in a complete loss of engine power, and the unsuitable terrain encountered by the pilot during the subsequent forced landing. Contributing to the accident were the night lighting condition, and trees.NTSB CHI07CA082Accident · No injuriesData collectionFinal reportCessna 172N · Pinckneyville, ILPresence of a deer on the runway resulting in an inadvertent collision during the landing roll.NTSB ATL07CA042Accident · No injuriesData collectionFinal reportPiper PA-12 · Elberton, GAThe passenger's inadvertent application of the left brake during landing roll, which resulted in a swerve to the left and impact with trees.NTSB NYC07IA063Incident · No injuriesIncident investigationFinal reportAirbus A-320-232 · New York, NYThe in-flight fire which was caused by the catastrophic failure of a 9-volt battery from an unknown cause.NTSB LAX07CA087Accident · 1 fatalData collectionFinal reportWampole Mini-Max · Adelanto, CAa loss of control for undetermined reasons.NTSB ENG07WA025Incident · No injuriesForeign investigationBoeing 747 · Seoul, South KoreaNTSB ENG07WA019Incident · No injuriesForeign investigationAirbus A300 · Shanghai, ChinaNTSB DFW07CA068Accident · No injuriesData collectionFinal reportFortuna Sonex · Atlanta, TXThe pilot's failure to maintain an adequate airspeed that resulted in a stall/mush. A contributing factor was the group of trees located near the departure end of the runway.NTSB DEN07WA061Accident · 3 fatalForeign investigationPiper PA-34-200T · Gresse-en-Verco, FranceNTSB DEN07CA070Accident · No injuriesData collectionFinal reportMooney M20K · Ingalls, KSThe pilot's inadequate in-flight planning and decision making, and failure to refuel while en route, resulting in loss of engine power during cruise due to fuel exhaustion. Contributing to the accident was the poor weather at the pilot's destination.NTSB LAX07CA086Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-3C · Jean, NVthe tow hook jamming and failing to release from the glider.NTSB LAX07CA085Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAthe student pilot's improper recovery from a bounced landing.