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 MIA07CA065Accident · No injuriesData collectionFinal reportCessna 172R · Orlando, FLThe student pilot's inadequate compensation for the wind conditions while landing. Factors associated with the accident are a crosswind and wind gusts.NTSB CHI07CA094Accident · No injuriesData collectionFinal reportMcCall Rotorway 162F · Malta, ILThe pilot's improper use of the rotorcraft flight controls resulting in a dynamic rollover during takeoff. A factor was the soft ground that the left skid encountered.NTSB SEA07CA084Accident · No injuriesData collectionFinal reportBoykin Rotorway Exec 162F · Camarillo, CAThe pilot's failure to maintain main rotor RPM resulting in an uncontrolled descent to a hard landing. A contributing factor was his lack of experience in make and model of aircraft.NTSB NYC07LA086Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Wawayanda, NYA failure of the crankshaft idler gear, which resulted in a total loss of engine power while maneuvering.NTSB DFW07LA088Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Laredo, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW07LA087Accident · No injuriesLimited investigationFinal reportPZL 101A · Spicewood, TXThe loss of engine power due to water contamination in the fuel system. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB CHI07LA095Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Austin, INThe pilot's improper preflight planning/preparation, and his failure to abort the takeoff. Contributing factors were a tailwind and a short runway.NTSB ATL07LA064Accident · No injuriesLimited investigationFinal reportBeech BE-90 · Augusta, GAA total failure of the electrical system for undetermined reasons, which resulted in the pilot's inability to ensure that the landing gear was down and locked.NTSB ATL07CA059Accident · No injuriesData collectionFinal reportStinson 108 · Lawrenceville, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop.NTSB ATL07CA056Accident · No injuriesData collectionFinal reportBeech B24R · Monks Corner, SCThe pilot's misjudgment of speed/distance/altitude which resulted in a undershoot of the runway.NTSB SEA07LA082Accident · Serious injuriesLimited investigationFinal reportHackney Glasair TD · Arvin, CALoss of engine power resulting from fuel exhaustion due to the pilot's failure to refuel the aircraft en route. A contributing factor to this accident was rough/uneven terrain at the forced landing site.NTSB SEA07LA081Accident · No injuriesLimited investigationFinal reportCessna T210N · Livermore, CAThe pilot's failure to maintain clearance from another aircraft holding on the taxiway while taxiing from landing. The pilot's inadequate visual lookout was a factor.NTSB SEA07CA083Accident · No injuriesData collectionFinal reportDuffy/Wagner Vans RV-4 · Ogden, UTThe pilot's inadequate fuel management resulting in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC07LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Catherine Twp., PAThe pilot's improper use of carburetor heat. Contributing to the accident were the weather conditions conducive to the formation of carburetor ice.NTSB NYC07FA083Accident · 3 fatalField investigationFinal reportPiper PA-32R-301 · Jacksonville, MDThe pilot's failure to maintain control of the airplane which was a result of spatial disorientation after takeoff into instrument conditions with an operationally degraded electronic primary flight display. Contributing to the accident were the pilot’s…NTSB MIA07CA064Accident · No injuriesData collectionFinal reportCessna 150 · Okeechobee, FLThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power during final approach, and a collision with a ditch.NTSB DEN07LA090Incident · No injuriesLimited investigationFinal reportBeech 200 · Angel Fire, NMThe pilot's inability to maintain clearance from the snow bank. Contributing factors were the pilot's failure to perform a go-around/missed approach procedure after observing snow removal equipment on the runway, the pilot's improper in-flight planning and…NTSB DEN07LA078Accident · No injuriesLimited investigationFinal reportDassault Mystere Falcon 900C · Rifle, COThe pilot's improper decision to land with excessive airspeed during the approach and failure to obtain the proper touchdown point, which resulted in a runway overrun. Contributing factors were the pilot's failure execute a missed approach, to use available…NTSB ATL07CA062Accident · No injuriesData collectionFinal reportPiper PA-28A-180C · Atlanta, GAThe pilot's failure to maintain directional control of the airplane while landing with a flat main tire.NTSB ATL07CA061Accident · Serious injuriesData collectionFinal reportHarrison Robert J. Longez · Morganton, NCThe pilot's failure to maintain an adequate airspeed that resulted in an inadvertent stall, and subsequent inflight collision with trees and the ground.NTSB ATL07CA055Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Myrtle Beach, SCThe loss of engine power due to undetermined reasons. A factor in the accident was the pilot's failure to follow emergency procedures when he failed to jettison the advertising banner prior to his forced landing in water.NTSB SEA07CA085Accident · No injuriesData collectionFinal reportPiper PA-18 · Tulare, CAThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC07CA084Accident · Minor injuriesData collectionFinal reportBell 206B · Lewes, DEThe pilot's inadequate visual lookout, which resulted in an in flight collision with utility wires during takeoff, and a subsequent impact with terrain.NTSB DFW07WA095Accident · No injuriesForeign investigationCessna 208B · Quepos, Costa RicaNTSB ATL07CA058Accident · No injuriesData collectionFinal reportCessna 172K · Cornelia, GAThe failure of the owner/operator to repair or replace a known leaking brake system components resulting in a total loss of brakes while taxing and an on-ground collision with trees.NTSB ENG07WA020Incident · No injuriesForeign investigationBoeing 747 · Shanghai, ChinaNTSB SEA07CA080Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta 2 · Taylorsville, UTThe flight instructor's failure to maintain aircraft control during the flare/touchdown while practicing an autorotation which resulted in a hard landing. A factor which contributed to the accident was the downdraft wind condition.NTSB DEN07LA077Accident · No injuriesLimited investigationFinal reportPiaggio Industrie P180 · Fort Lauderdale, FLThe first officer's loss of directional control during landing causing the left main gear to collapse. Contributing factors in this accident were the flight crew's excessive use of brakes causing the left main tire to blow out, and the captain's inadequate…NTSB ATL07LA057Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Atlanta, GAThe improper maintenance of the "B-nut" fitting adjacent to the fuel pump by maintenance personnel, resulting in a fuel leak and wing explosion.NTSB ATL07CA053Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Oliver Springs, TNThe pilot's failure to maintain adequate clearance, resulting in an in-flight collision with an airport sign.NTSB SEA07LA079Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Marysville, CAThe failure of the pilot to maintain a proper glidepath while on final approach and his failure to maintain clearance, which resulted in an undershoot and subsequent collision with the runway's approach light standards. A factor was the approach light…NTSB SEA07CA078Accident · No injuriesData collectionFinal reportCessna 150A · Davenport, WAThe pilot's failure to maintain directional control while landing, which resulted in a nose over. Wind gusts and the pilot's inadequate compensation for the wind condition were factors.NTSB MIA07CA061Accident · Minor injuriesData collectionFinal reportBruce E. Hotz Wind Wagon · Leesburg, FLThe failure of the pilot to abort the takeoff after recognizing that the engine rpm was 760 less than desired after becoming airborne, and the inability of the airplane to maintain a positive rate of climb resulting in a controlled descent, and in-flight…NTSB ERA10CA112Accident · No injuriesData collectionFinal reportBellanca 7ECA · Calhoun City, MSThe pilot's failure to maintain clearance from a fallen tree located off the right side of the runway during takeoff.NTSB ENG07WA016Incident · No injuriesForeign investigationLockheed L188C · Stansted, United KingdomNTSB DFW07CA086Accident · No injuriesData collectionFinal reportBrantly Helicopter B2 · Vernon, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN07WA075Accident · 1 fatalForeign investigationBeech 24R · Rendsburg-Schac, GermanyNTSB CHI07LA092Accident · No injuriesLimited investigationFinal reportSocata TB-20 Trinidad · Rhinelander, WIThe failure of the pilot to maintain directional control of the airplane during taxi. A contributing factor was the gusting winds and sign.NTSB NYC07CA082Accident · No injuriesData collectionFinal reportCessna 172P · Sanford, FLThe student pilot's failure to maintain directional control during the landing roll. Factors included a 90-degree crosswind, and the student pilot's improper in-flight decision to land on a runway with the crosswind rather than on an available runway with a…NTSB MIA07LA063Accident · Serious injuriesLimited investigationFinal reportJimenez Reymundo Challenger II Specia · Arecibo, PRThe uncertificated pilot's failure to remove the aft seat belt from around the aft control stick prior to flight.NTSB LAX07LA114Accident · No injuriesLimited investigationFinal reportMooney M20B · St. George, UTOil contamination of the right magneto. Factors were the airplane owner's failure to comply with manufacturer's service bulletins and overhaul porcedures.NTSB DFW07CA085Accident · Minor injuriesData collectionFinal reportCessna 150 · Brownfield, TXThe pilot's failure to maintain aircraft control while maneuvering. A contributing factor was the gusty wind conditions.NTSB ATL07LA054Accident · 1 fatalLimited investigationFinal reportJames Walter Hornet · Talbotton, GAThe failure of the right main fuel line, resulting in fuel starvation and a loss of engine power.NTSB ATL07CA060Accident · No injuriesData collectionFinal reportMaule M-5 235C · Moultrie, GAThe pilot's failure to maintain directional control of the airplane during landing roll.NTSB OPS07IA003Incident · No injuriesIncident investigationFinal reportBoeing 737-700 · Las Vegas, NVThis incident was caused by failure of the LC2 controller to comply with coordination procedures and runway separation standards. Contributing was the failure of LAS ATCT management to establish procedures requiring positive separation of aircraft operations…NTSB NYC07LA081Accident · No injuriesLimited investigationFinal reportCessna 500 · Beverly, MAThe inadequate guidance and procedures provided by the airplane manufacturer regarding operation of the pneumatic de-icing boots. Also causal was the Federal Aviation Administration's inadequate directives which failed to require manufacturers to direct…NTSB LAX07LA113Accident · 2 fatalLimited investigationFinal reportPiper PA-28-151 · Lincoln City, ORIn-flight collision with water for undetermined reasons.NTSB LAX07CA111Accident · Serious injuriesData collectionFinal reportCessna 182 · Diamond Lake, ORFuel exhaustion due to the pilot's inadequate preflight inspection and failure to verify the fuel supply. A factor was the night lighting condition.NTSB DFW07FA084Accident · 1 fatalField investigationFinal reportBeech 58P · Marietta, OKThe pilot's improper landing flare. A contributing factor was the premature touchdown in an area of rising terrain.NTSB CHI07LA091Accident · Serious injuriesLimited investigationFinal reportHaddan Sonerai IIL · Fort Atkinson, WIThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons. A low altitude and an inadvertent stall were factors.