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 LAX90TL004Accident · No injuriesClass 3Final reportNorth American F-86E · Okinawa, JapanOn June 5, 1990, at about 1300 local time, a Canadair F-86E (mk.6), N93FS, owned by tractor flight system, inc of santa ana, California and operated by the U.S. Air force, was involved in an accident and was destroyed during a public use, instructional…NTSB FTW90DRD11Accident · No injuriesFinal reportBell 47G3-B · Houma, LAThe pilot's failure to maintain rotor RPM and an excessive sink rate.NTSB DEN90LA132Accident · No injuriesLimited investigationFinal reportLund Mustang II · Hamilton, MTThe inadequate compensation for the wind conditions by the pilot.NTSB MKC90LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcpherson, KSPoor pre-flight and in-flight planning and refueling not performed by the pilot in command.NTSB MIA90LA138Accident · Minor injuriesLimited investigationFinal reportSpezio Sport DAL-1 · Columbus, MSFailure of the pilot to maintain adequate airspeed, resulting in an inadvertent stall and subsequent loss of control. A related factor was: the lack of a stall warning system installed in the aircraft.NTSB LAX90LA208Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Truckee, CAThe pilot's improper decision to release from the tow airplane at an insufficient altitude on the lee side of the mountains.NTSB LAX90LA207Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Colusa, CAThe pilot's failure to maintain directional control during touchdown.NTSB FTW90DRD10Accident · No injuriesFinal reportGrumman G-164B · Mamou, LAPilot misjudged wind information. Factors contributing to the accident were the tailwind, the trees and the levee.NTSB FTW90DPA04Accident · No injuriesFinal reportBoeing A75N1 · Longview, TXThe pilot's abrupt use of the wheel brakes during the landing roll.NTSB DEN90LA125Accident · No injuriesLimited investigationFinal reportCessna 188A · Martin, SDThe on-ground loss of control during the takeoff ground run. Contributing to this accident was the pilot's failure to use optimum takeoff flaps for the runway conditions that existed, and the soft wet runway surface.NTSB DEN90LA124Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Sturgis, SDPilot inadvertently stalling the airplane. Contributing to the accident was the pilot's lack of total experience.NTSB DEN90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Douglas, WYThe accident to be improper installation of aileron control system by maintenance personnel, and failure to perform an aircraft preflight by the pilot in command.NTSB CHI90DEC02Accident · Minor injuriesFinal reportSchweizer G-164C · Sandusky, MIThe pilot's failure to maintain adequate airspeed during the swath run turn.NTSB BFO90FA054Accident · 2 fatalField investigationFinal reportCessna 172RG · Onego, WVVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain adequate clearance (altitude) from mountainous terrain. The terrain and adverse weather conditions were related factors.NTSB SEA90FA091Accident · 1 fatalField investigationFinal reportCessna 172K · Tacoma, WAThe pilot did not adequately maintain a proper glide path for landing which resulted in an inflight collision with a tree.NTSB MIA90LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe improper landing flare by the pilot in command.NTSB FTW90LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student pilot misjudged the flare to land.NTSB FTW90LA113Accident · No injuriesLimited investigationFinal reportLuscombe 11 · Fort Worth, TXLoss of control on the ground, due to a locked left brake, undetermined reasons.NTSB FTW90DPJ07Accident · Minor injuriesFinal reportCessna T188C · Altus, OKThe PIC did not maintain the proper clearance from the powerline.NTSB DEN90LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Belgrade, MTThe inadvertent stall experienced during the attempted forced landing.NTSB DEN90FA120Accident · 1 fatalField investigationFinal reportCessna 170A · Dillon, COImproper planning/decision by the pilot, and his failure to maintain airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the high density altitude and terrain conditions.NTSB CHI90LA149Accident · No injuriesLimited investigationFinal reportBeech F33A · Port Clinton, OHThe pilot failed to maintain aircraft control after encountering gusty wind conditions during the takeoff roll.NTSB CHI90FA146Accident · 4 fatalField investigationFinal reportBeech A36 · Gaylord, MIThe pilot's inadequate airspeed, while maneuvering (turning) after takeoff, which resulted in a stall/mush. Factors related to the accident were: the pilot's improper planning/decision, failure to maintain weight and balance limits, and adverse wind…NTSB CHI90DEV05Accident · Minor injuriesFinal reportCessna 172P · Jerseyville, ILThe pilot's failure to go around when crosswinds upset aircraft alignment with the runway in the flare. Contributing to the accident was the pilot's attempt to land in crosswinds which exceeded the maximum for which the model has been demonstrated capable.NTSB ATL90DKG04Accident · No injuriesFinal reportAir Command 532 · Rome, GAThe pilot attempted a flat spiraling spin maneuver at an altitude that was too low to effect a safe recovery.NTSB SEA90LA092Accident · No injuriesLimited investigationFinal reportCessna 182A · Tekoa, WAThe pilot turned off the carburetor heat while descending for landing in conditions conducive to carburetor icing.NTSB NYC90LA124Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Barre, MAThe premature commanded tow release by the towplane pilot over unsuitable terrain.NTSB LAX90LA205Accident · Minor injuriesLimited investigationFinal reportCessna 152 II · Rialto, CAPilot's inadequate visual outlook which resulted in an inflight encounter with wake turbulence produced by a hovering helicopter.NTSB LAX90DVG09Accident · No injuriesFinal reportCullen/Roth Falcon XP · Yountville, CAThe pilot's misjudgement of fuel supply.NTSB FTW90DPJ06Accident · 1 fatalFinal reportStits SA-3A Playboy · Bartlesville, OKAn inadvertent stall.NTSB DEN90LA121Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Las Cruces, NMA loss of power for an unknown cause. A factor in the accident was the unsuitable terrain.NTSB DCA90MA030Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 737-2X6C · Unalakleet, AKDeficiencies in flightcrew coordination, their failure to adequately prepare for and properly execute the unk LOC rwy 14 nonprecision approach and their subsequent premature descent.NTSB CHI90LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, MIStudent pilot's failure to maintain directional control while landing in a crosswind. The student's lack of flight experience and the crosswind were factors.NTSB CHI90LA147Accident · No injuriesLimited investigationFinal reportCessna C205 · Anderson, INThe pilot's encounter with unsuitable terrain during the landing roll after a forced landing. Contributing factors in this accident were the total powerplant failure and the IFR weather conditions which limited the landing site selection.NTSB CHI90FA145Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Wadsworth, OHThe failure of the certified flight instructor and the dual student to maintain a visual lookout during the final approach to the airport.NTSB BFO90FA053Accident · 2 fatalField investigationFinal reportBeech 36 · Gaithersburg, MDFailure of the pilot to extend the landing gear, which resulted in a wheels up landing; his improper decision to attempt a go around (aborted landing) after the airplane contacted the runway; and his failure to attain or maintain adequate airspeed while…NTSB ATL90LA125Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Montevallo, ALThe inattentiveness of the glider pilot to the aborted takeoff of the tow plane, which resulted in his delayed action in attempting to execute a forced landing. These actions resulted in an inadvertent stall and the aircraft collided with the terrain.NTSB ANC90LA083Accident · No injuriesLimited investigationFinal reportHelio H-250 · Six Mile Lake, AKThe pilot's improper flare, which resulted in a hard landing. The pilot's lack of experience in the make and model of aircraft was a related factor.NTSB SEA90LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Palouse, WAThe pilots poorly planned approach for landing.NTSB MKC90DPG02Accident · 1 fatalFinal reportAero Commander S-2R · Alicia, ARThe pilot's failure to maintian airspeed during the turn to reverse direction for a swath run.NTSB DEN90FA119Accident · 1 fatalField investigationFinal reportCessna 152 · Longmont, COThe pilot continued into hazardous weather conditions.NTSB CHI90LA143Accident · No injuriesLimited investigationFinal reportCessna 172N · Northwood, OHThe pilot's improper in-flight planning/decision, which resulted in an off-airport landing, when the engine lost power due to fuel exhaustion. The fact that the engine lost power over a populated area was a factor in this accident.NTSB CHI90DEX01Accident · Minor injuriesFinal reportSattler Aeroduster SA750 · Columbus, INFailure of the pilot to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. The pilot's lack of experience in the airplane was a related factor.NTSB ANC90LA082Accident · No injuriesLimited investigationFinal reportDe Havilland DHC2 · Broad Pass, AKThe pilot's continued flight into known adverse weather, and his delay in reversing course (improper in-flight planning/decision). Factors related to the accident were: terrain and weather conditions.NTSB ANC90LA081Accident · No injuriesLimited investigationFinal reportMaule M4 · L. Susitna Riv, AKThe pilot's fuel mismanagement in not having sufficient fuel to reach his destination.NTSB NYC90LA123Accident · No injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAImproper maintenance and inspection by maintenance personnel of the left gear torque link attachment.NTSB NYC90LA122Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Becket, MAA power loss due to oil starvation, after maintenance personnel failed to comply with Lycoming directives during the engine overhaul. Factors related to the accident were: improper adjustment of the engine oil pressure by maintenance personnel and unsuitable…NTSB FTW90LA112Accident · No injuriesLimited investigationFinal reportMooney M-20F · Aledo, TXInadequate preflight planning/preparation, in as much as the performance data was not used by the pilot in command. Factors were the high density altitude, inadequate airspeed, and premature liftoff.NTSB CHI90LA144Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Carbondale, ILThe pilot's inability to maintain directional control during the touchdown and landing roll.NTSB BFO90LA052Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-126E · Warrenton, VAThe pilot misjudged his landing approach.