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 MIA07LA133Accident · Serious injuriesLimited investigationFinal reportBeech B36TC · Clearwater, FLThe pilot's improper rotation and climb during the takeoff which resulted in a stall/mush, a descent, and an impact with the ground.NTSB DEN07LA138Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Alamosa, COThe failure of the number one cylinder due to fatigue. Contributing to the accident was the pilot's diminished visual lookout due to the oil covered windscreen.NTSB CHI07LA273Accident · 1 fatalLimited investigationFinal reportTerpstra Exec 162F · Winamac, INThe inadequate installation of the horizontal stabilizer bracket by the pilot, the fatigue fracture seperation of vertical stabilizer bracket during cruise flight, and the aircraft control not possible by the pilot.NTSB ATL07LA115Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Siassconset, MAThe non-instrument rated pilot's loss of control at night in instrument flight conditions due to spatial disorientation. A factor was the pilot's in-flight decision not to inform the controller that he was not instrument rated.NTSB ANC07LA088Accident · No injuriesLimited investigationFinal reportPiper J-3 · Big Lake, AKThe flight instructor's delayed instructions to apply the carburetor heat, and his inadequate supervision. A factor contributing to the accident was carburetor icing conditions.NTSB ANC07CA089Accident · No injuriesData collectionFinal reportCessna U206G · Iliamna, AKThe pilot's inadequate compensation for gusty wind conditions, which resulted in the float-equipped airplane's right wing striking the bottom of the shallow lake, while taxiing for takeoff. A factor contributing to the accident was the gusty wind condition.NTSB LAX07CA255Accident · No injuriesData collectionFinal reportBeech D55 · Heber, UTThe pilot's failure to lower the landing gear during landing.NTSB CHI07LA272Accident · 1 fatalLimited investigationFinal reportClifford Titan Tornado II · Henning, MNThe inadvertent stall and low airspeed while maneuvering. A contributing factor was the low altitude of the maneuver.NTSB CHI07CA282Accident · No injuriesData collectionFinal reportMooney M20M · Grand Rapids, MIThe pilot not maintaining directional control of the aircraft during the crosswind landing. Factors were the crosswind and the runway lights that were impacted.NTSB CHI07CA274Accident · No injuriesData collectionFinal reportCessna 140 · Grant, NEThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gust, and ditch.NTSB ANC07MA083Accident · 5 fatalMajor investigationFinal reportde Havilland DHC-2 · Ketchikan, AKAn inadvertent aerodynamic stall resulting from the pilot's poor decision-making and inadequate planning and execution when he took off toward nearby rising terrain, in strong winds, under circumstances where his options for maneuvering were severely limited…NTSB ANC07LA086Accident · No injuriesLimited investigationFinal reportAeronca AR-15 · Clear, AKThe loss of engine power during cruise flight for an undetermined reason.NTSB ANC07LA085Accident · No injuriesLimited investigationFinal reportCessna 207 · Fairbanks, AKThe loss of engine power in cruise flight due to a lack of sufficient oil. A factor contributing to the accident was the pilot's improper in-flight decision to continue the flight after noting a loss of oil pressure.NTSB ANC07CA087Accident · No injuriesData collectionFinal reportMaule M7 · Bettles, AKThe pilot's selection of an unsuitable landing site, which resulted in an encounter with soft terrain, and a nose over during the landing roll.NTSB OPS07IA009Incident · No injuriesIncident investigationFinal reportBoeing 737-700 · Los Angeles, CAThe LAX north ground controller's failure to properly coordinate with the tower local controller prior to providing taxi instructions that permitted an aircraft to cross an active runway while another aircraft was departing. **This report was modified on…NTSB NYC07IA194Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · New Bern, NCA failure of the stabilator control cable turnbuckle terminal fitting due to corrosion. Contributing to the accident were the mechanic's inadequate annual inspection, and the aircraft manufacturer's failure to provide adequate information in its maintenance…NTSB NYC07FA193Accident · 2 fatalField investigationFinal reportCessna 172N · Rochester, NYThe pilot's failuire to maitain adequate airspeed during a turning maneuver which resulted in an inadvertent stall.NTSB LAX07CA256Accident · No injuriesData collectionFinal reportCessna 150L · Keystone Height, FLthe student pilot's excessive retraction of flaps and failure to attain an adequate airspeed during a go-around that led to a stall/mush.NTSB DFW07IA184Incident · Minor injuriesIncident investigationFinal reportBell 407 · Gulf of MexicoFatigue failure of the power turbine outer shaft for undetermined reasons.NTSB DFW07CA196Accident · No injuriesData collectionFinal reportInterplane Skyboy · Atoka, OKThe pilot's improper landing flare, resulting in a hard landing.NTSB ANC07LA081Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235 · Fairbanks, AKThe reversal of the elevator control cables by maintenance personnel, and the inadequate preflight inspection by the flight instructor and dual student.NTSB NYC07IA199Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301T · Alton, ILThe component manufacturer's inadequate fabrication of the transient voltage suppressor.NTSB LAX07CA252Accident · No injuriesData collectionFinal reportCessna 140 · Olympia, WAThe pilot's failure to maintain directional control during landing.NTSB LAX07CA251Accident · No injuriesData collectionFinal reportCessna R182 · Coeur D'Alene, IDthe instructor's misjudged landing flare.NTSB LAX07CA249Accident · No injuriesData collectionFinal reportAviat Husky A-1B · Moab, UTThe pilot's failure to maintain directional control that resulted in a ground loop.NTSB DFW07WA188Accident · 1 fatalForeign investigationPiper PA-25-235 · Tamoyo, Dominican RepublicNTSB DFW07LA183Accident · 1 fatalLimited investigationFinal reportHuggles Sonex · Bonham, TXThe pilot's failure to maintain control of the airplane on take off, which resulted in an inadvertent stall and subsequent collision with terrain.NTSB DFW07CA213Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Tunica, MSThe pilot's failure to compensate for the existing wind conditions during a crosswind landing. A factor was the crosswind.NTSB DEN07WA146Accident · No injuriesForeign investigationRobinson R-22 Beta II · Wiener Neustadt, AustriaNTSB DEN07FA136Accident · 2 fatalField investigationFinal reportZlin Aviation s.r.o. Savage · Mosquero, NMThe pilot's failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall. Contributing to the accident was the conflicting airspeed information provided by the manufacturer, the incorrect airspeed indicator markings, and the high density…NTSB ATL07CA118Accident · No injuriesData collectionFinal reportPiper PA28-140 · Front Royal, VAThe pilot's improper recovery from a bounced landing.NTSB SEA07LA234Accident · No injuriesLimited investigationFinal reportCessna 182P · Nampa, IDThe total loss of engine power due to the carburetor throat becoming obstructed with paint that had pealed off of the induction air inlet channel in an area where paint should not have been applied. Factors include an earthen berm running across the field…NTSB SEA07CA235Accident · No injuriesData collectionFinal reportCessna 172B · Seattle, WAThe private pilot's failure to see the approaching large wake swell, both during his landing and the subsequent takeoff, and the failure of the instructor pilot to insure that the private pilot's visual lookout was effective enough to detect the oncoming…NTSB LAX07CA250Accident · No injuriesData collectionFinal reportCessna 182H · Page, AZthe pilot's failure to maintain clearance with obstructions while taxiing behind parked airplanes.NTSB DEN07LA137Accident · No injuriesLimited investigationFinal reportMooney M20R · Wichita, KSthe pilot's improper flare and recovery from a bounced landing. Contributing factors are the lack of experience of the pilot and the delayed remedial action of the airline transport pilot rated passenger.NTSB ATL07CA114Accident · No injuriesData collectionFinal reportWaco Classic YMF-5 · Nantucket, MAThe pilot's failure to maintain control of the airplane during takeoff roll, which resulted in an on ground collision with an airport sign.NTSB ANC07FA082Accident · 2 fatalField investigationFinal reportMaule M-5-180C · Arctic Village, AKThe pilot's failure to maintain sufficient airspeed to avoid a stall/spin while maneuvering.NTSB SEA07CA233Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Tucson, AZThe student pilot's failure to maintain rotor RPM during landing approach, and the delayed remedial action by the flight instructor. A contributing factor was the high density altitude weather condition.NTSB OPS07IA008Incident · No injuriesIncident investigationFinal reportLearjet 45 · Teterboro, NJA runway incursion occurred when the local controller did not ensure that N145AP has passed the intersection of runways 1 and 6 prior to authorizing N336FX to depart runway 1.NTSB DFW07CA182Accident · No injuriesData collectionFinal reportCessna 182 · Montrose, PAThe pilot's failure to attain the proper touchdown point. A contributing factor was the prevailing tailwind.NTSB DEN07CA154Accident · No injuriesData collectionFinal reportCessna 172R · Fort Collins, COThe student pilot's improper flare and recovery from a bounced landing.NTSB ANC07WA091Accident · 3 fatalForeign investigationCirrus SR-22 · Spirit River, CanadaNTSB SEA07CA230Accident · No injuriesData collectionFinal reportCessna 195 · San Diego, CAThe pilot's inadequate compensation for a wind gust that ballooned the airplane during the landing flare, which resulted in a hard landing. A contributing factor was the wind gust.NTSB SEA07CA229Accident · Serious injuriesData collectionFinal reportQuicksilver Manufacturing GT-500 · Newberg, ORThe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall and uncontrolled descent to terrain impact. A contributing factor was the pilot's lack of certification.NTSB NYC07LA192Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Frenchtown, NJA partial loss of engine power for undetermined reasons.NTSB NYC07CA190Accident · No injuriesData collectionFinal reportAckert Dakota Hawk DH23 · Sebring, FLPreexisting cracking of the landing gear tubing.NTSB ENG07IA034Incident · No injuriesIncident investigationFinal reportLearjet · Salt Lake City, UTThe fatigue fracture of the fan blade due to the blade vendor's improper setup of the forging dies, which resulted in fan blades with airfoils that were below the minimum thickness in the highest stressed area of the airfoil and resulted in operating stresses…NTSB DFW08WA037Accident · 3 fatalForeign investigationCessna 206 · Zihuatanejo, MexicoNTSB DFW07CA185Accident · No injuriesData collectionFinal reportBell 206 · Houma, LAThe pilot's failure to properly secure all loose items prior to takeoff.NTSB CHI07CA268Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Cooksville, ILThe partial loss of engine power during the takeoff roll for undetermined reasons and the pilot's unsuccessful compensation for the tailwind conditions. Factors contributing to the accident were the tailwind and the corn crop.