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 CHI99LA259Accident · No injuriesLimited investigationFinal reportCessna 180 · Tower, MNfailure of the operator of the boat to maintain clearance with the floatplane.NTSB CHI99LA242Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bristol, WIthe pilot's failure to perform a proper recovery from the bounced landing, resulting in the airplane's nose gear striking the runway. A factor relating to the accident was the excessive airspeed maintained during the landing.NTSB CHI99LA236Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Wahoo, NEThe pilot's improper starting technique which resulted in the inadvertent starting of the engine, with no one in the airplane.NTSB ANC99LA105Accident · No injuriesLimited investigationFinal reportNix Avid Flyer · Chugiak, AKA loss of engine power for an undetermined reason.NTSB SEA99LA122Accident · No injuriesLimited investigationFinal reportCessna 150M · Glenns Ferry, IDThe pilot's failure to maintain directional control during the attempted takeoff. A related factor was the pilot's lack of recent experience.NTSB SEA99LA120Accident · 2 fatalLimited investigationFinal reportAnderson Rans S-12 · Bowmont, IDAircraft control was not maintained while maneuvering at low altitude. An inadvertent stall was a factor.NTSB SEA99FA126Accident · 2 fatalField investigationFinal reportCessna T-337 G-P · Snoqualmie Pass, WAThe pilot's failure to maintain clearance from mountainous terrain while maneuvering below low ceilings. Factors include low ceilings and inadequate in-flight planning.NTSB NYC99MA178Accident · 3 fatalMajor investigationFinal reportPiper PA-32R-301 · Vineyard Haven, MAThe pilot's failure to maintain control of the airplane during a descent over water at night, which was a result of spatial disorientation. Factors in the accident were haze, and the dark night.NTSB NYC99LA179Accident · No injuriesLimited investigationFinal reportAllen-Charles Barracuda · Hermon, NYThe pilot's inadequate preflight planning which resulted in a precautionary landing. A factor in this accident was the pilot's selection of unsuitable terrain for the precautionary landing.NTSB MIA99LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Dunedin, FLThe pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power.NTSB LAX99LA254Accident · No injuriesLimited investigationFinal reportPiper PA32R-300 · Mammoth Lakes, CAThe pilot's failure to attain and maintain an adequate airspeed for the prevailing density altitude. The pilot's failure to abort the takeoff is also causal.NTSB IAD99LA055Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Millbrook, NYwas the pilot's inadequate compensation for winds and his failure to maintain directional control.NTSB FTW99TA194Accident · No injuriesFinal reportBell 47G-3B-1 · Sour Lake, TXThe pilot's failure to adequately preflight the helicopter's fuel system resulting in the total loss of engine power as a result of water contamination. Factors were the incorrect filter installed on the fueling truck and the pilot's improper touchdown…NTSB FTW99FA192Accident · 3 fatalField investigationFinal reportMBB BK-117-B2 · Fresno, TXthe loss of control during approach due to the corrosion of the T-T strap which resulted in fatigue cracking and subsequent separation of the strap and main rotor blade from the helicopter.NTSB CHI99LA240Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Butler, MOloss of engine power for undetermined reason, and the pilot's inability to maintain clearance from the fence during the forced landing. Factors relating to this accident were the rising terrain, the rough/uneven terrain, and the fence posts.NTSB CHI99LA235Accident · Serious injuriesLimited investigationFinal reportPiper J-3C · Maple Lake, MNThe pilot's inadequate preflight planning that resulted in exceeding the maximum gross weight of the airplane and the subsequent inadvertent aerodynamic stall.NTSB CHI99FA238Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Yorkville, ILthe pilot continuing into known adverse weather conditions, attempting low altitude flight, and not maintaining terrain clearance. Factors to the accident were the thunderstorm and the improper weather evaluation by the pilot following pre-departure and…NTSB ATL99LA109Accident · 1 fatalLimited investigationFinal reportBlackburn John D. Jr. Bushby M II · Daytona Beach, FLThe pilot's failure to securely reconnect the distributor coil wire during routine maintenance. Factors were the unsuitable terrain and trees.NTSB SEA99LA124Accident · No injuriesLimited investigationFinal reportNavion B · Stanley, IDAn improperly planned approach and gusting wind conditions. A tailwind was a factor.NTSB LAX99LA252Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Taft, CAThe pilot's selection of the wrong runway in consideration of the wind conditions and his subsequent failure to maintain directional control. The pilot's decision to abort the landing attempt with inadequate runway remaining for the takeoff phase was also…NTSB FTW99LA191Accident · No injuriesLimited investigationFinal reportBell OH-58A · Bastrop, LAThe failure of the refueling truck's filter to separate water resulting in the water contamination in the helicopter's fuel system and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA033Accident · No injuriesLimited investigationFinal reportCessna T210M · Cedar City, UTThe pilot's failure to follow alternate landing gear extension procedures. Factors were the main landing gear failure to extend and a loss of electrical power.NTSB CHI99LA239Accident · No injuriesLimited investigationFinal reportCessna 411 · Troy, MIEngine explosion/fire during start for undetermined reason.NTSB ATL99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Kissimmee, FLThe pilot's improper flare and recovery from a bounced landing.NTSB ATL99LA108Accident · No injuriesLimited investigationFinal reportHiller UH12-C · Venice, FLLoss of engine power due to fuel starvation as a result of the passenger inadvertently shutting off the fuel supply.NTSB SEA99WA117Accident · 2 fatalForeign investigationPiper PA-32-300 · Clinton, CanadaNTSB NYC99LA177Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-300-600ER · Jamaica, NYimproper use of the flight controls by the captain trainee, and inadequate supervision by the check airman.NTSB NYC99LA176Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Sanford, METhe pilot's failure to maintain control of the airplaneNTSB NYC99IA175Incident · No injuriesIncident investigationFinal reportPiper PA-46-310P · Belmar, NJThe failure of the turbocharger clamp, resulting from improper welding settings during manufacture.NTSB MIA99LA197Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLthe pilot's improper in-flight decisions allowing the glider to descend to a low altitude, resulting in a forced landing off the airport and subsequent impact with a tree.NTSB IAD99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Granville, NYThe pilot's not maintaining a proper glidepath during the visual approach to the runway.NTSB FTW99TA190Accident · Minor injuriesFinal reportHughes 269C · Houston, TXThe hard landing as a result of the flight instructor's failure to attain the proper airspeed before simulating an engine failure, which resulted in the development of a high sink rate. Factors were the night illumination and the soft ground.NTSB ANC99LA092Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Juneau, AKThe pilot's failure to maintain rotor rpm, and an inadequately planned approach. A factor associated with the accident was a tailwind.NTSB SEA99LA119Accident · No injuriesLimited investigationFinal reportCessna 185 · Renton, WAFailure of the pilot-in-command to maintain directional control after landing, resulting in a ground loop.NTSB SEA99LA118Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Opheim, MTThe pilot's failure to maintain an airspeed above stall speed (Vs), resulting in a stall/mush into the terrain during a course reversal at the end of an aerial application run. Factors include hilly terrain and high density altitude.NTSB MIA99LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Boca Raton, FLa total loss of engine power due to a failed oil pump impeller which resulted in a forced landing and a subsequent hard landing on a golf course.NTSB FTW99LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Springtown, TXThe pilot's failure to maintain clearance with the trees during the initial takeoff climb. A factor was the high density altitude.NTSB DEN99LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Englewood, COThe flight instructor's failure maintain aircraft control. A factor was the inadequate supervision by the flight instructor.NTSB CHI99LA237Accident · No injuriesLimited investigationFinal reportCessna 172L · Montezuma, IAthe pilot inadvertently landed on the wrong runway and exceeded the proper touchdown point on the runway. Factors associated with the accident were the gusty tailwind, the fence, and the ditch.NTSB ATL99LA107Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Camden, ALThe failure of the cyclic control rod due to an overstress separation resulting from a material defect (inadequate quality of material) by the manufacturer.NTSB LAX99MA251Accident · 2 fatalClass 1 · MajorFinal reportSchempp-Hirth Nimbus 4DM · Minden, NVThe pilot's excessive use of the elevator control during recovery from an inadvertently entered spin and/or spiral dive during which the glider exceeded the maximum permissible speed, which resulted in the overload failure of the wings at loadings beyond the…NTSB FTW99LA188Accident · No injuriesLimited investigationFinal reportBeech C35 · Jonesboro, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors were the prevailing tailwind, and the airplane's over gross weight condition.NTSB CHI99TA232Accident · No injuriesFinal reportHughes OH-6A · Chesterfield, MOthe pilot-in-command's improper autorotational landing.NTSB CHI99LA241Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Aitkin, MNthe right spring in the tailwheel assembly's separation. Factors were the fatigue in the landing gear, the maintenance personnel not identifying the fatigue during the annual inspection, and the right main gear's separation.NTSB CHI99LA234Accident · Serious injuriesLimited investigationFinal reportGrimm SEA Hawker · Princeton, MNThe erratic aileron control response for undetermined reasons. A factor was the tree.NTSB CHI99LA233Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Mcville, NDthe pilot not attaining a proper climb rate. Factors were the stall/mush and the ditch.NTSB ATL99LA106Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Panther Burn, MSThe pilot's failure to maintain clearance that resulted in the in-flight collision with trees. A factor was his diverted attention following the failure of the DGPS.NTSB SEA99LA131Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Snohomish, WABrake system failure due to the presence of air bubbles in the hydraulic fluid.NTSB SEA99LA115Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Paul, IDThe pilot's failure to attain adequate airspeed during takeoff and initial climb, resulting in stall/mush and inability of the aircraft to sustain level flight. Factors included high density altitude, a tailwind, an uphill takeoff surface, and crops in the…NTSB SEA99LA114Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Shelley, IDThe pilot-in-command's failure to maintain adequate clearance with obstacles. A contributing factor were the trees.