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 ATL07LA052Accident · Minor injuriesLimited investigationFinal reportBell 47G2A · Huntsville, ALThe loss of engine power due to undetermined reasons.NTSB MIA07FA060Accident · 1 fatalField investigationFinal reportAero Vodochody Aero. Works L-39C · Titusville, FLThe pilot’s failure to ensure sufficient altitude while maneuvering in close proximity to the ground during an airshow, which resulted in an impact with terrain.NTSB MIA07CA107Accident · No injuriesData collectionFinal reportRobinson R-44-II · Isla Grande, PRThe pilot's inadvertent encounter with a loss of tail rotor effectiveness which resulted in damage to the helicopter during the subsequent hard landing.NTSB LAX07CA112Accident · No injuriesData collectionFinal reportCaywood Long-Ez · El Cajon, CAThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB LAX07CA110Accident · No injuriesData collectionFinal reportCessna T210N · Barstow, CAThe pilot's failure to properly execute the manual landing gear extension procedures.NTSB DEN07CA076Accident · No injuriesData collectionFinal reportCessna 172E · Pleasanton, KSThe pilot's failure to maintain control of the airplane during a go-around. Contributing factors were the gusts and crosswinds.NTSB CHI07LA093Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Chicago, ILThe contained fan blade tip separation following the ingestion of several birds into the left engine during takeoff and the lack of an adequate response time available to crew to avert the bird strike.NTSB MIA07LA059Accident · No injuriesLimited investigationFinal reportRobinson R-44-II · Miami, FLThe pilot's failure to maintain sufficient rotor rpm during an autorotative landing, which resulted in a hard landing and separation of the tailboom.NTSB LAX07LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Paris, IDa loss of power in the right engine for undetermined reasons.NTSB ATL07CA051Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Collinwood, TNThe pilots improper inflight planning which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA07CA076Accident · No injuriesData collectionFinal reportCessna 182H · Phoenix, AZThe pilot's inadequate preflight inspection, resulting in fuel exhaustion and the loss of power. A factor was the sign.NTSB LAX07CA107Accident · No injuriesData collectionFinal reportPietsch IT · Douglas, AZa loss of directional control during landing due to separation of the rudder cable. A factor was the soft dirt terrain.NTSB CHI07CA090Accident · No injuriesData collectionFinal reportCessna 172E · Big Rapids, MIThe student pilot's failure to maintain directional control of the airplane during takeoff which led to the impact with the snow banks adjacent to the runway. The snow banks were contributing factors in the accident.NTSB DEN07LA074Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pueblo, COThe pilot of the North American SNJ-5 warbird's inadequate visual lookout while taxiing, resulting in an on-ground collision with the stationary Grob motor glider.NTSB DEN07FA071Accident · 1 fatalField investigationFinal reportBeech A23A · Holman, NMThe pilot's failure to maintain a safe altitude and clearance, and his improper inflight planning/decision to postpone initiating a climbing turn to avoid obstructions.NTSB DEN07CA073Accident · No injuriesData collectionFinal reportAerospatiale SA315B · Norwood, COThe inflight collision with a bird(s).NTSB DEN07CA072Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Broomfield, COThe instructor's failure to maintain aircraft control. A contributing factor was the windshear.NTSB CHI07CA088Accident · No injuriesData collectionFinal reportPiper PA-24-400 · Des Moines, IAthe nose landing gear becoming jammed in a partially extended position during flight as a result of damage to the nose landing gear by ground personnel.NTSB NYC07LA077Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Plymouth, MAThe student pilot's failure to maintain control of the helicopter during a hover, and the flight instructor's delayed remedial action.NTSB NYC07CA076Accident · Minor injuriesData collectionFinal reportBellanca 17-30A · Farmingdale, NJThe pilot's failure to verify the amount of fuel onboard before takeoff. Factors in the accident were the airplane being under fueled, the refueler's experience, the airplane's inoperative fuel gauges, unsuitable terrain for landing, and night lighting…NTSB LAX07CA105Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Groveland, CAthe pilot's failure to maintain directional control.NTSB ATL07CA050Accident · Minor injuriesData collectionFinal reportCessna 172K · Paris, TNThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.NTSB SEA07LA075Accident · No injuriesLimited investigationFinal reportFound Aircraft Canada FBA-2C2 · Reno, NVThe certified flight instructor's failure to maintain directional control of the airplane during landing, which resulted in a groundloop.NTSB NYC07CA079Accident · No injuriesData collectionFinal reportBeech C23 · Fredericksburg, VAThe pilot's misjudgment of the airplane's speed and distance during the landing approach.NTSB LAX07CA104Accident · No injuriesData collectionFinal reportSchleicher ASW-27B · Williams, CAThe pilot's misjudged distance/altitude and delay in retracting the spoilers that led to an undershoot, which resulted in a collision with terrain.NTSB CHI07MA083Accident · 1 fatalMajor investigationFinal reportMcDonnell Douglas 369FF · Haena, HIThe fatigue failure of the tail rotor blade root fitting due to a manufacturing defect which resulted in the separation of the tail rotor system and loss of tail rotor control. A contributing factor to the accident were the trees that the helicopter struck…NTSB CHI07CA089Accident · No injuriesData collectionFinal reportCessna 172R · Columbus, OHThe pilot's failure to maintain directional control while landing. Contributing factors to the accident were the wind conditions and the runway sign.NTSB ATL07CA049Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Ocraacoke, NCThe pilot's improper use of the aileron and rudder controls and inadequate compensation for the wind conditions during a crosswind landing resulting in a loss of directional control.NTSB ANC07CA024Accident · No injuriesData collectionFinal reportCessna 177 · Gridwood, AKThe pilot's selection of a snow-covered runway for landing, which resulted in a quick stop and damage to the airplane. A factor associated with the accident was the snow-covered runway.NTSB SEA07CA077Accident · No injuriesData collectionFinal reportCessna 172S · Kingman, AZThe pilot's misjudged flare, which resulted in a hard landing and a porpoise.NTSB DFW07CA083Accident · No injuriesData collectionFinal reportCessna 150 · Sand Springs, OKThe pilot's improper recovery from a bounced landing.NTSB DEN07FA068Accident · Minor injuriesField investigationFinal reportFlight Design USA CT-SW · Albuquerque, NMThe total failure of the left main landing gear strut due to overload during the landing resulting in the loss of control and subsequent nose over. A factor contributing to the accident was the chief pilot 's inability to maintain directional control of the…NTSB CHI07FA084Accident · 2 fatalField investigationFinal reportBeech 58 · Munster, INThe fuel starvation for an undetermined reason which led to the loss of power on the left engine. Additional causes were the pilot's failure to maintain airspeed which led to his loss of control of the airplane. Factors in the accident were the flight…NTSB CHI07CA085Accident · Minor injuriesData collectionFinal reportPolcyn Long-EZE · St. Charles, MOA loss of engine power for undetermined reasons. A factor in the accident was the inadvertent lift-off that occurred during the high speed taxi checks.NTSB CEN10WA040Accident · No injuriesForeign investigationColumbia LC42-550FG · Casarrubios del Monte, SpainNTSB ANC07CA023Accident · No injuriesData collectionFinal reportCessna 172 · Chugiak, AKThe instructor pilot's inadequate supervision of the student while landing, which resulted in an undershoot, and subsequent in-flight collision with snow-covered terrain.NTSB WAS07WA009Accident · 2 fatalForeign investigationPiper PA-34-200T · Lilongwe, MalawiNTSB SEA07CA074Accident · Minor injuriesData collectionFinal reportCessna 172N · Phoenix, AZThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and uncontrolled descent into terrain during landing. A contributing factor was the pilot's distracted attention due to the inaccurate flap indicator.NTSB NYC07MA073Accident · 4 fatalMajor investigationFinal reportAerospatiale AS350BA · Princeville, HIThe failure of maintenance personnel to properly tighten (torque) the flight control servo lower attachment clevis, and reinstall a functioning lock washer, which resulted in a flight control disconnect and a complete loss of helicopter control. Contributing…NTSB NYC07CA078Accident · No injuriesData collectionFinal reportCessna 172R · Norfolk, VAThe pilot's failure to maintain directional control while landing, which resulted in a collision with a runway sign. A factor was the crosswind.NTSB NYC07CA074Accident · No injuriesData collectionFinal reportMooney M20R · Marshfield, MAA loss of directional control for undetermined reasons.NTSB MIA07LA066Accident · No injuriesLimited investigationFinal reportEADS PZL Warsza PZL-104M Wilga · Tampa, FLThe pilot's failure to maintain directional control during the landing roll which resulted in a ground loop and damage to the airplane.NTSB CHI07CA087Accident · No injuriesData collectionFinal reportCessna 150 · LaCrosse, WIThe dual student's failure to maintain the proper glidepath and clearance from terrain and the flight instructor's delayed remedial action. A factor was the flight instructor's fatigue.NTSB NYC07CA072Accident · No injuriesData collectionFinal reportSud SE3130 Alouette II · Davenport, VAThe pilot's inadequate visual lookout, which resulted in an in flight collision with utility wires during takeoff, and a subsequent impact with terrain.NTSB LAX07FA103Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Tooele, UTThe pilot exceeded the design stress limits of the airplane, which resulted in the in-flight separation of the wings and horizontal stabilizers. Contributing to the accident were the night lighting conditions, clouds, turbulence and icing conditions.NTSB DFW07LA082Accident · No injuriesLimited investigationFinal reportCessna T210R · Boerne, TXThe pilot of the other airplane's failure to maintain proper spacing during approach to landing and subsequent go-around, which resulted in a midair collision.NTSB CHI07LA086Accident · 1 fatalLimited investigationFinal reportCamair 480 · East Liberty, OHThe uncontrolled descent for undetermined reasons.NTSB SEA07CA072Accident · No injuriesData collectionFinal reportCessna T210M · Boulder City, NVThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a runway excursion.NTSB DEN07WA067Accident · Minor injuriesForeign investigationEurocopter EC120B · Vreden, GermanyNTSB DCA07RA030Accident · 23 fatalForeign investigationBoeing B737-400 · Yogyakarta, Indonesia