NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 GAA18CA082Accident · No injuriesData collectionFinal reportPiper PA28 · Pocasset, OKThe pilot’s improper approach path, which resulted in the airplane landing short of the runway.NTSB GAA18CA077Accident · No injuriesData collectionFinal reportCzech Sport Aircraft a.s. Sport Cruiser · Sacramento, CAThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB DCA18WA077Incident · No injuriesForeign investigationBoeing 767 · Almaty, KazakhstanKazakhstan's Aviation Accident Investigation Department has notified the NTSB of an incident involving a Boeing 767, which occurred on December 9, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as…NTSB CEN18LA051Accident · No injuriesLimited investigationFinal reportCessna 172C · Algona, IAThe No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.NTSB WPR18FA045Accident · 3 fatalField investigationFinal reportBeech C90 · Geneva, FLThe pilot's loss of airplane control due to spatial disorientation during an instrument approach in instrument meteorological conditions, and the flight instructor's delayed remedial action. Contributing to the accident was the flight instructor's impairment…NTSB GAA18CA078Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.NTSB GAA18CA075Accident · Minor injuriesData collectionFinal reportJones Kent C Vans RV-10 · Limon, COThe pilot’s unstabilized approach and failure to go around at night, which resulted in the airplane impacting a power line and a subsequent hard landing.NTSB GAA18CA073Accident · No injuriesData collectionFinal reportBrock Steiner Sport Copter Vortex · Spanish Fork, UTThe pilot’s failure to maintain situational and geographic awareness during the flight, which resulted in him becoming lost and exhausting the gyroplane’s fuel.NTSB ERA18FA046Accident · 5 fatalField investigationFinal reportBeech 58 · St. CroixThe non-multiengine rated pilot's failure to maintain airplane control during a single-engine approach. Contributing to the accident was a total loss of engine power on the left engine due to detonation for reasons that could not be determined based on the…NTSB WPR18LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna 172D · Auburn, WAThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB GAA18CA070Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Santa Rosa, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB DCA18CA055Accident · Serious injuriesData collectionFinal reportAirbus A321 231 · Fort Lauderdale, FLan inadvertent encounter with convective turbulence that resulted in a flight attendant injury.NTSB CEN18FA049Accident · 1 fatalField investigationFinal reportRaytheon B36TC · Chesterfield, MOThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR18LA044Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 34-200T · Glendale, AZThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the fatigue of the left main landing gear assembly.NTSB GAA18CA081Accident · No injuriesData collectionFinal reportPiper PA 32 · Cheboygan, MIThe pilot’s failure to maintain the airplane’s rate of descent in gusting wind conditions resulting in a hard landing and runway excursion.NTSB GAA18CA072Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Fort Pierce, FLThe pilot’s improper landing flare, which resulted in a tail strike and hard landing.NTSB GAA18CA068Accident · No injuriesData collectionFinal reportNorth American T 6 · Chesapeake, VAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion and nose over.NTSB ERA18WA042Accident · 2 fatalForeign investigationRobinson R44 · Dubovaya Balka, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…NTSB ERA18LA041Accident · No injuriesLimited investigationFinal reportPiper PA28 · Brewton, ALThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN18LA047Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Rockford, ILThe pilot's inadequate preflight planning and his decision to depart without the required fuel reserve, which resulted in fuel exhaustion during a night approach and subsequent loss of engine power.NTSB WPR18LA043Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · Rio Oso, CAAn in-flight fire due to electrical arc corrosion of the fuel line.NTSB GAA18CA071Accident · No injuriesData collectionFinal reportCessna 402 · Hyannis, MAEncounter with a flock of birds during takeoff at night, resulting in multiple bird strikes and structural damage.NTSB DCA18WA029Accident · No injuriesForeign investigationCanadair CL 600 2A12 · Caracas, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CANADAIR LTD CL 600 2A12 airplane that occurred on December 04, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation…NTSB CEN18LA048Accident · No injuriesLimited investigationFinal reportPiper PA 31-310 · Jeffersonville, INThe right main landing gear’s failure to fully extend for reasons that could not be determined because postaccident testing revealed no mechanical anomalies that would have precluded normal operation.NTSB WPR18LA042Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Everett, WAThe flight instructor’s inadequate preflight inspection, during which he failed to ensure that water was sufficiently drained from the fuel system, which resulted in total loss of engine power and a subsequent forced landing and impact with objects.NTSB GAA18CA079Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Chino, CAThe pilot’s failure to maintain directional control during a touch-and-go landing.NTSB ERA18LA044Accident · No injuriesLimited investigationFinal reportPiper PA34 · Thomasville, GAA stone becoming lodged in a left main landing gear (MLG) drag link, which resulted in the failure of the left MLG to extend and lock.NTSB ERA18LA043Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Frederick, MDThe pilot's improper landing flare, which resulted in a bounced landing and the failure of the left main landing gear tire.NTSB DCA18CA043Accident · No injuriesData collectionFinal reportAirbus A319 115 · Miami, FLThe failure of the flight crew of N9011P to maintain an appropriate clearance from N344PP, which was stopped on the taxiway.NTSB CEN18FA045Accident · 1 fatalField investigationFinal reportPiper Titan Tornado II D · Ravenna, OHThe pilot's failure to maintain adequate airspeed following a loss of engine power during final approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB WPR18WA061Accident · Minor injuriesForeign investigationEnstrom 480 · Bacoor, PhilippinesOn December 2, 2017, at 0900 universal time coordinated, a Enstrom Helicopter Corporation 480B, RP-C8955, was substantially damaged during a precautionary landing near Bacoor, Cavite, Philippines. The pilot was not injured, and the passenger sustained minor…NTSB GAA18CA085Accident · No injuriesData collectionFinal reportCessna 172 · Park Rapids, MNThe student pilot’s improper landing flare, which resulted in the propeller striking the ground.NTSB GAA18CA069Accident · No injuriesData collectionFinal reportWeaver David A Pulsar 912XP · Plato Center, ILThe pilot’s decision to continue to land without visual reference to the airport in low light conditions. Contributing to the accident was the pilot’s inability to activate the private airport’s pilot-controlled lighting system due to its configuration.NTSB ERA18LA039Accident · 2 fatalLimited investigationFinal reportKevin Leue Sparrow Hawk · Hernando, MSImpact with trees and terrain for reasons that could not be determined based on available evidence.NTSB ANC18LA013Accident · No injuriesLimited investigationFinal reportCessna 172R · Huntingdon, TNA total loss of engine power for reasons that could not be determined because a postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA18CA067Accident · No injuriesData collectionFinal reportTodd Foley Zenith 701 · Mount Airy, NCThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB ERA18LA040Accident · No injuriesLimited investigationFinal reportChampion 7EC · Ravenswood, WVThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion.NTSB ANC18LA014Accident · No injuriesLimited investigationFinal reportCessna 172 · Miami, FLThe pilot's decision to continue the landing after a loss of visual cues during a night landing.NTSB WPR18LA041Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Truckee, CAThe flight instructor’s failure to execute a power recovery from a non-stabilized autorotative descent, which resulted in a hard landing.NTSB GAA18CA076Accident · No injuriesData collectionFinal reportCessna 152 · Fullerton, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA074Accident · No injuriesData collectionFinal reportCessna 172 · Bowie, MDThe pilot’s failure to maintain situational awareness during the approach to land. Contributing to the accident was the pilot’s distraction by the instrument panel during the approach.NTSB ERA18RA045Accident · 2 fatalForeign investigationPiper PA28 · Vereda El Mortillo, ColombiaimportNTSB GAA18CA066Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · New Orleans, LAThe pilot’s failure to land the helicopter with both skids on the trailer platform, which resulted in a loss of control.NTSB ERA18LA034Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Westminister, MDThe student pilot's failure to maintain a proper glidepath during the approach due to his distraction by the failure of an avionics panel, which resulted in a runway undershoot.NTSB ERA18CA035Accident · No injuriesData collectionFinal reportDriggers Quillan E Titan Tornado · Mechanicsville, VAThe pilot’s inadequate preflight inspection and failure to detect water contamination in the fuel system, which resulted in a partial loss of engine power on takeoff.NTSB DCA18WA048Incident · No injuriesForeign investigationBoeing 777 · Singapore, SingaporeThe Transport Safety Investigation Bureau (TSIB) of Singapore has notified the NTSB of an incident involving a Boeing 777, which occurred on November 29, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex…NTSB DCA18WA027Accident · Serious injuriesForeign investigationBoeing 757 224 · Bogota, ColombiaThe Colombia Civil Aviation Authority (CAA) has notified the NTSB of an accident involving a Boeing 757, which occurred on November 28, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State…NTSB DCA18IA026Incident · No injuriesClass 3 · IncidentFinal reportBoeing 737-932ER · Atlanta, GAThe flight crewmembers’ failure to properly monitor the airplane’s flightpath, which caused the approach to become unstabilized and resulted in the airplane’s descent below the decision altitude while misaligned with the localizer course. Contributing to the…NTSB ANC18CA017Accident · No injuriesData collectionFinal reportPiper PA 18-125 · Nikolai, AKThe pilot’s improper decision to contact an unsuitable landing surface, which resulted in a nose-over.NTSB DCA18LA024AccidentClass 3 · LimitedFinal reportBoeing 777 · Jamaica, NYThe air traffic controller's improper instruction to the Egypt Air airplane flight crew to pass in an area where passing is prohibited, which led to a ground collision.