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 ERA11LA175Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Birmingham, ALA total loss of engine power for undetermined reasons.NTSB ERA11CA202Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Allentown, PAThe pilot's failure to adequately compensate for crosswind conditions, resulting in a hard landing.NTSB ERA11CA178Accident · No injuriesData collectionFinal reportIniziative Industriali Italian SKY Arrow 600 Sport · Ridgely, MDThe pilot's failure to compensate for crosswind conditions and loss of directional control during landing, resulting in a runway excursion and nose over.NTSB ERA11CA174Accident · Serious injuriesData collectionFinal reportPiper J3C-65 · Maysvile, NCThe pilot-rated passenger’s loss of directional control during takeoff and the pilot’s delayed remedial action, which resulted in a runway excursion and collision with trees.NTSB CEN11CA215Accident · No injuriesData collectionFinal reportArion Lightning · Brownsville, TXThe pilot’s failure to maintain adequate airspeed on final approach, resulting in a loss of control and a hard landing.NTSB WPR11LA151Accident · No injuriesLimited investigationFinal reportBell 206B-III · Tooele, UTThe pilot did not maintain yaw control of the helicopter during a maneuvering hover. Contributing to the accident was the pilot’s lack of experience in the make and model helicopter.NTSB CEN11WA474Accident · Minor injuriesForeign investigationRobinson R44 · Forestville, CanadaOn March 1, 2011, at 1618 eastern standard time, a Robinson R44II, Canadian registration C-FNZO, collided with the terrain in Forestville, Canada, shortly after departing from the Forestville Airport (CYFE). The helicopter was substantially damaged. The pilot…NTSB CEN11CA213Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Glenwood Springs, COThe pilot’s improper takeoff procedure, which resulted in a dynamic rollover when the left skid contacted the ground.NTSB WPR11LA149Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Naches, WAThe airplane's encounter with moderate turbulence at a higher altitude than the flight crew expected, resulting in an injury to a cabin crewmember.NTSB WPR11FA147Accident · 1 fatalField investigationFinal reportNeefjes Lancair 360 MK-II · Milford, UTThe pilot's loss of control of the airplane due to spatial disorientation after inadvertently entering instrument meteorological conditions. Contributing to the accident were the pilot's inadequate preflight preparation, his en route decision-making, and his…NTSB WPR11CA148Accident · No injuriesData collectionFinal reportCessna A150M · Grass Valley, CAThe aircraft's encounter with deep snow during the landing roll out. Contributing to the accident was the airport manager's failure to update the AWOS recording to reflect the closure of the runway due to snow.NTSB ERA11LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Welch, WVThe unlicensed pilot’s decision to land on a closed runway with a tailwind, his failure to attain the proper touchdown point, and his delayed decision to attempt a go-around, resulting in a collision with trees.NTSB ERA11LA167Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Auburn, ALA loss of engine power due to an internal failure of the muffler that was not detected by maintenance personnel.NTSB ENG11WA050Incident · No injuriesForeign investigationBell UH1H · Manuwatu, New Zealand, New ZealandWhile conducting a positioning flight between Blenheim (South Island NZ) to a lifting job in Raurimu (Central North Island NZ) at approximately 2000 feet altitude, the pilot of a Bell UH1H helicopter, registration number ZK-HSP, noticed the oil pressure…NTSB DCA11WA032Accident · 4 fatalForeign investigationGrumman G21 · Al Ain, United Arab EmiratesNTSB CEN11LA210Accident · No injuriesLimited investigationFinal reportCessna LC42-550FG · Llano, TXThe pilot's improper recovery from a bounced landing.NTSB CEN11LA207Accident · Serious injuriesLimited investigationFinal reportCessna 310K · Angleton, TXThe pilot's failure to maintain control of the airplane during a night instrument approach.NTSB CEN11CA212Accident · No injuriesData collectionFinal reportBeech G35 · Brenham, TXThe pilot’s failure to extend the landing gear during the approach resulting in a gear-up landing.NTSB WPR11LA150Accident · No injuriesLimited investigationFinal reportCessna 140A · Newark, CAA loss of engine power due to water contamination in the fuel system as a result of the pilot’s inadequate preflight inspection to identify and remove the water.NTSB WPR11FA145Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Phoenix, AZThe pilot and flight instructor's failure to adequately monitor the flight task and environment while maneuvering to maintain sufficient altitude with rising terrain in dark night conditions and the flight instructor's improper decision to practice in an area…NTSB WPR11CA146Accident · No injuriesData collectionFinal reportHiller UH-12E · Colusa, CAThe pilot's failure to maintain an adequate airspeed and an inadvertent encounter with settling with power while flying downwind.NTSB ERA11FA165Accident · 1 fatalField investigationFinal reportBritish BAC 167 Strikemaster · Kingston, NYThe pilot’s failure to maintain airplane control while maneuvering. Contributing to the accident was the pilot's lack of experience in the accident airplane.NTSB ERA11CA169Accident · No injuriesData collectionFinal reportLiberty Aerospace Liberty XL-2 · Burlington, NCThe student pilot's improper recovery from a bounced landing.NTSB ERA11CA166Accident · Minor injuriesData collectionFinal reportEnstrom F-28C · Fort Pierce, FLThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11WA214Accident · 2 fatalForeign investigationCessna P210 · Armentières sur Avre, FranceUnder the jurisdiction and control of the French government.NTSB CEN11LA209Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Kingsville, TXA pre-existing crack in the front spar of the right horizontal stabilizer near a riveted fitting, causing it to fail and separate from the airplane in flight. Contributing to the accident was the failure of maintenance personnel comply with existing service…NTSB CEN11CA206Accident · No injuriesData collectionFinal reportWaco SRE · Vidalia, LAThe pilot’s failure to maintain directional control during landing in gusty wind conditions.NTSB ERA11CA171Accident · No injuriesData collectionFinal reportAerostar PA-60-601P · Princeton, NJThe pilot’s failure to stop the airplane resulting in a runway overrun.NTSB DCA11CA036Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 190-100 IGW · New York, NYImproper latching of the aft galley cart prior to landing.NTSB CEN11LA204Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Andrews, TXThe pilot's failure to maintain adequate airspeed during an emergency descent, following a loss of engine power, which resulted in an inadvertent stall.NTSB WPR11GA144Accident · Minor injuriesFinal reportEurocopter AS 350 B2 · Riverside, CAThe failure of both pilots to follow proper procedures during a simulated hydraulic emergency that resulted in a loss of helicopter control. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA11CA162Accident · No injuriesData collectionFinal reportBell 206 · Ridgeland, SCThe certified flight instructor's delayed remedial action during a practice autorotation, which resulted in a hard landing.NTSB CEN11FA202Accident · Minor injuriesField investigationFinal reportCessna T210M · Independence, MOLatent dimensional discrepancies related to the engine crankcase main bearing saddle bores, which precipitated the fatigue failure of the crankshaft and a complete loss of engine power. Contributing to the accident was the engine manufacturer's failure to…NTSB CEN11FA201Accident · 1 fatalField investigationFinal reportCessna 421C · Connersville, INThe pilot did not maintain control of the airplane while making a low-altitude turn during dark night conditions.NTSB CEN11CA203Accident · No injuriesData collectionFinal reportCessna 195A · Hannibal, MOThe pilot's inability to maintain control during landing due to seized main landing gear wheels, which caused the airplane to nose over.NTSB WPR11LA143Accident · No injuriesLimited investigationFinal reportMooney M20F · Nephi, UTThe failure of the nose gear during landing for reasons that could not be determined due to postaccident damage.NTSB ERA11LA156Accident · No injuriesLimited investigationFinal reportCessna 172G · Clarksville, FLA loss of engine power due to fuel starvation as a result of the owner's improper maintenance of the fuel selector valve, which resulted in a lack of fuel supply from the right fuel tank.NTSB ENG11WA020Accident · No injuriesForeign investigationAgustawestland AW139 · JeJu International Airport, South KoreaOn February 23, 2011 at about 8:20 pm (local), a Korean Coast Guard Agusta Westland AW139 crashed into shallow seas about 70 miles west of JeJu International Airport, Republic of Korea with 4 crewmembers and 1 passenger on board. The helicopter took off from…NTSB CEN11LA200Accident · No injuriesLimited investigationFinal reportHughes 369D · Henryetta, OKFailure of the cyclic control system for reasons undetermined.NTSB ANC11CA013Accident · No injuriesData collectionFinal reportPiper PA-18 · Sterling, AKThe airplane owner improper fabrication of a fuel line, and subsequent inadequate inspection by an aviation mechanic, resulting in a loss of engine power.NTSB WPR11CA142Accident · No injuriesData collectionFinal reportPiper PA-31P-350 · North Bend, ORThe pilot's failure to lower the landing gear while on approach to landing. Contributing to the accident was the pilot's failure to follow a written checklist during the approach portion of the flight.NTSB ERA11WA211Accident · 6 fatalForeign investigationCessna 340 · Tachira, VenezuelaOn February 22, 2011, about 1915 UTC, a Cessna 340A, Venezulian registration YV2402, operated by Premezolados Agreconsa C.A., collided with mountainous terrain near Tachira, Venezuela. Visual meteorological conditions prevailed at the destination airport…NTSB CEN11CA208Accident · No injuriesData collectionFinal reportBeech 58 · Prospect Heights, ILThe pilot's inadequate flare, which resulted in a hard landing.NTSB CEN11CA199Accident · No injuriesData collectionFinal reportCessna 310Q · Romeoville, ILThe pilot's failure to maintain adequate airspeed during the approach/landing to compensate for the ice accumulated on the airframe which resulted in a hard landing.NTSB ENG11WA049Incident · No injuriesForeign investigationBoeing 737 · Casablanca, Morocco, MoroccoOn February 21, 2011 the crew of a Royal Air Maroc Boeing 737-800, registration number CN-ROR, while approximately 20 miles from their destination airport of Casablanca Mohammaed V, reported an automatic in-flight shut down of the right hand engine, a…NTSB CEN11IA198Incident · No injuriesIncident investigationFinal reportBoeing 737-823 · Southlake, TXThe tractor driver’s failure to confirm that the tow bar head/handle was secured correctly to the airplane.NTSB CEN11CA197Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Holdenville, OKThe pilot’s decision to land with a tailwind and his delay in executing a go around.NTSB ERA11FA151Accident · 1 fatalField investigationFinal reportCessna 150E · Ware Shoals, SCThe non-certificated pilot's impairment due to alcohol and a sedating antihistamine, which resulted in his failure to maintain airspeed and the subsequent aerodynamic stall and ground impact.NTSB ERA11CA152Accident · Serious injuriesData collectionFinal reportAirbus A320-232 · North Fayston, VTThe airplane's inadvertent encounter with turbulence during the approach, which resulted in serious injury to a flight attendant.NTSB CEN11FA220Accident · No injuriesField investigationFinal reportMooney M20J · Romeoville, ILThe collapse of the left main landing gear during the landing roll for undetermined reasons.