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 LAX07LA075Accident · Minor injuriesLimited investigationFinal reportJihlavan KP-5 · Moorpark, CAa partial loss of power for undetermined reasons.NTSB DFW07CA063Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's encounter with porpoise following a hard landing and the improper recovery from a bounced landing.NTSB DFW07CA060Accident · No injuriesData collectionFinal reportTanker DR-107 One Design · Rockwall, TXA loss of engine power for an undetermined reason during a go-around, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN07CA056Accident · No injuriesData collectionFinal reportCessna 172R · Olathe, KSThe pilot's improper flare during landing and failure to maintain directional control during the landing roll. Factors were the gusting winds and the crosswinds.NTSB DFW07WA062Accident · Serious injuriesForeign investigationHiller UH-12B · Panama City, PanamaNTSB DEN07IA055Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Cripple Creek, COA fatigue fracture, which resulted in the separation of the No.1 engine fan disk. Contributing factors in the accident were the operators' maintenance personnel lack of training to be able to detect arc-out damage on the fan disk, and the fan disk…NTSB DCA07WA023Accident · No injuriesForeign investigationRaytheon B-1900 · Samedan, SwitzerlandNTSB CHI07FA060Accident · Minor injuriesField investigationFinal reportBeechcraft BE99 · Milwaukee, WIThe failure of both pilots to adequately scan for and avoid other aircraft traffic during taxi operations, and the failure of Air Traffic Control to issue a traffic advisory to both of the pilots. A contributing factor to the accident was the night time light…NTSB SEA07LA053Accident · Minor injuriesLimited investigationFinal reportRoss Hummer Pitts Special · Stockton, CAThe pilot's inadvertent ground loop/swerve, resulting in a nose over during an aborted takeoff. A contributing factor was the uneven runway surface, which restricted the pilot's ability to maintain directional control.NTSB NYC07FA058Accident · Serious injuriesField investigationFinal reportCessna 550 · Butler, PAThe copilot's failure to maintain the proper airspeed, and failure to obtain the proper touchdown point, and the pilot-in-command's inadequate supervision, which resulted in an overrun. Contributing to the accident was the PIC's failure to activate the speed…NTSB DFW07CA058Accident · No injuriesData collectionFinal reportCessna 152 · McAlester, OKThe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose landing gear.NTSB DEN07WA064Incident · No injuriesForeign investigationCessna 550 Bravo · Samedan, SwitzerlandNTSB SEA07LA052Accident · No injuriesLimited investigationFinal reportCessna 172D · Beaver Marsh, ORThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA07CA054Accident · No injuriesData collectionFinal reportCessna 140 · Murrieta, CAThe pilot's excessive application of brakes during taxi after landing, resulting in a nose over.NTSB MIA07LA043Accident · No injuriesLimited investigationFinal reportRyan Navion · Marco Island, FLA reported loss of engine power shortly after takeoff for undetermined reasons.NTSB ENG07WA024Incident · No injuriesForeign investigationAirbus Industrie A300-600 · Kota Kinabalu, MalaysiaNTSB ATL07LA034Accident · No injuriesLimited investigationFinal reportGreenhaw, William Lancair 360 · Guntersville, ALFailure of an unapproved automotive fuel line installed by the owner/pilot mechanic which resulted in an engine fire during taxi after landing.NTSB CHI07CA061Accident · No injuriesData collectionFinal reportPiper J3C-65 · White Lake, SDThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and a nose over. A factor associated with the accident was the crosswind.NTSB LAX07CA094Accident · No injuriesData collectionFinal reportGeneral Balloon AX-6 · San Martin, CAThe pilot's failure to maintain adequate altitude/clearance from power lines.NTSB LAX07CA073Accident · No injuriesData collectionFinal reportRobinson R-22 Beta 2 · Salem, ORThe student pilot's improper remedial action when a dynamic rollover was encountered.NTSB DEN07CA057Accident · No injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Craig, COThe pilot's improper in-flight planning and unsuitable area selected for landing. A contributing factor was the snow covered terrain and runway.NTSB ATL07LA033Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Wauchula, FLThe pilot's improper flare which resulted in a hard landing and overload failure of the right landing gear strut.NTSB LAX07CA074Accident · No injuriesData collectionFinal reportQuad City Ultralight Challenger Special · Orland, CAThe pilots improper in-flight decision to continue the flight rather than refuel resulting in fuel exhustion and the loss of engine power.NTSB ENG07RA012Incident · No injuriesForeign investigationDassault FALCON900 · Gatwick, United KingdomNTSB CHI07LA070Accident · Minor injuriesLimited investigationFinal reportReisinger Sonerai II L · Alma, MIThe loss of engine power during takeoff-initial climb for an undetermined reason. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB NYC07CA059Accident · No injuriesData collectionFinal reportCessna 182E · Ashland, VAThe pilot's failure to properly secure the seat locking pin.NTSB LAX07CA072Accident · Minor injuriesData collectionFinal reportBell Helicopter 206BIII · Springville, CAThe pilot's failure to maintain terrain/obstacle clearance while maneuvering. Factors were the mountainous terrain, trees, and low-altitude flight maneuvers.NTSB NYC07CA057Accident · No injuriesData collectionFinal reportFoley James Searey · Danbury, CTCollapse of the left main landing gear due to previous damage. A factor in the accident was the inadequate annual condition inspection.NTSB DEN07FA054Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Centennial, WYthe pilot's inadvertent flight into adverse weather conditions resulting in a loss of aircraft control. Contributing factors include the pilot's improper preflight planning and decision making, the pilot's spatial disorientation, the pilot's lack of night…NTSB DEN07FA053Accident · 2 fatalField investigationFinal reportCessna 182R · Waltman, WYthe pilot's continued visual flight rules (VFR) flight into instrument meteorological conditions (IMC) and failure to maintain terrain clearance resulting in controlled flight into terrain. Contributing factors were the pilot's improper preflight and…NTSB LAX07CA071Accident · Serious injuriesData collectionFinal reportBalloon Works Firefly 9B-15 · Peoria, AZThe balloon’s inadvertent encounter with a downdraft, which resulted in a hard landing.NTSB DEN07CA052Accident · No injuriesData collectionFinal reportCessna 120 · La Salle, COThe pilot's failure to maintain clearance from the ground. Contributing factors included the pilot's intentional low pass and his misjudging his altitude.NTSB ANC07LA016Accident · No injuriesLimited investigationFinal reportDouglas C54G-DC · Nenana, AKThe failure of an engine cylinder during cruise flight, which resulted in an in-flight fire, and subsequent emergency gear-up landing on snow-covered tundra. A factor in the accident was the failure of the fire suppression equipment to extinguish the fire.NTSB SEA07LA049Accident · No injuriesLimited investigationFinal reportCessna 150A · Cottonwood, AZThe pilot's failure to compensate for a gusty crosswind during the landing roll, which resulted in a loss of control and an on-ground encounter with a ditch. Factors associated with the accident are a crosswind and wind gusts.NTSB SEA07IA058Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Parowan, UTThe inadequate design of the engine mount, which caused an uncommanded left turn during the landing roll, loss of directional control, and impact with snow-covered terrain.NTSB NYC07FA056Accident · 1 fatalField investigationFinal reportBeech A36 · Wayne, NJThe pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB DEN07LA051Accident · No injuriesLimited investigationFinal reportPiaggio Industrie P180 · Eagle, COThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB SEA07LA048Accident · Serious injuriesLimited investigationFinal reportNavion G Model · El Centro, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the glare from the sun.NTSB MIA07FA042Accident · 2 fatalField investigationFinal reportPartenavia P 68C · Adjuntas, PRThe pilot's failure to maintain altitude/clearance with mountainous terrain for undetermined reasons during a normal descent under instrument meteorological and dark night conditions.NTSB DFW07CA057Accident · No injuriesData collectionFinal reportLuscombe 8A · El Paso, TXThe pilot's foot becoming lodged behind the right rudder pedal which resulted in a loss of directional control during landing.NTSB SEA07CA047Accident · No injuriesData collectionFinal reportCessna 140 · San Jose, CAThe pilot's excessive use of the airplane's wheel brakes, which resulted in a nose over during landing.NTSB MIA07LA039Accident · No injuriesLimited investigationFinal reportCessna 177 · Carrabelle, FLThe failure of maintenance personnel to detect corrosion and a fatigue crack during the last annual inspection.NTSB MIA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Tampa, FLThe inadequate design of the engine mount by the manufacturer, resulting in fatigue failure at the actuator attach foot and partial collapse of the nose landing gear.NTSB MIA07CA040Accident · Serious injuriesData collectionFinal reportJim Garrison N11 · Titusville, FLThe failure of the pilot to abort the takeoff after becoming airborne during taxi testing, and the failure of the pilot to maintain airspeed after becoming airborne resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with a tree.NTSB DEN07WA050Accident · No injuriesForeign investigationPiper PA-34-200 · Saint Francois, GuadeloupeNTSB ANC07LA015Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of directional control on the ground, and the wing impacting the snow-covered terrain. A factor associated with the accident was the snow-covered terrain.NTSB SEA07CA045Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Maricopa, AZThe excessive brake application during landing which resulted in a nose over.NTSB MIA07LA036Accident · No injuriesLimited investigationFinal reportCessna 182Q · Coral Springs, FLThe improper design change associated with a Supplemental Type Certificate (STC), which resulted in an in-flight fire.NTSB LAX07MA069Accident · 2 fatalMajor investigationFinal reportCessna 525 · Van Nuys, CAThe pilot's failure to maintain an adequate airspeed during the initial climb resulting in an inadvertent stall/spin. Contributing to the accident were the second pilots inadequate preflight, failure to properly secure the front baggage door, and the front…NTSB ENG07IA009Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-36 · Chicago, ILComplete loss of No. 2 engine power due to a partial rim failure of the 2nd stage turbine wheel, resulting in No. 2 engine shutdown and turbine debris exiting the side of the engine. The wheel failure mechanism could not be determined due to missing turbine…