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 CEN09CA368Accident · No injuriesData collectionFinal reportGrob G103 · Wellington, COThe pilot’s failure to maintain control of the glider during takeoff.NTSB WPR09LA270Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Yerington, NVThe pilot's failure to maintain aircraft control while maneuvering during an aerial application flight.NTSB WPR09CA295Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Dixie, IDThe pilot's excessive braking during the landing roll.NTSB OPS09IA008Incident · No injuriesIncident investigationFinal reportAirbus A320 · Boston, MAThe vehicle operator's failure to follow the designated haul route to the construction site and his failure to adhere to airport driving procedures, which led to missed visual cues and lack of required communication prior to crossing the active runway.…NTSB ERA09LA356Accident · 1 fatalLimited investigationFinal reportChris Mitchell Titan Tornado · Chadbourn, NCThe pilot’s failure to maintain aircraft control during initial climb following a loss of engine power. The reason for the power loss was not determined.NTSB ERA09FA355Accident · Serious injuriesField investigationFinal reportSchweizer 269C-1 · Naples, FLA loss of engine power due to the improper installation of the right magneto by maintenance personnel resulting in subsequent loss of engine power. Contributing to the accident was the inadequate 100-Hour inspection by the mechanic when he failed to note that…NTSB CEN09CA367Accident · No injuriesData collectionFinal reportCessna 152 · Fort Collins, COThe pilot's failure to control the airplane after engine startup, resulting in a ground collision with a nearby airplane.NTSB WPR09LA293Accident · 2 fatalLimited investigationFinal reportChampion 7ECA · Lake Elsinore, CAA loss of airplane control for undetermined reasons.NTSB WPR09CA294Accident · No injuriesData collectionFinal reportDornier ALPHA-JET · Arlington, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident were the distractions created by the pilot incorrectly setting a radio frequency and by his fixation on an airplane that was on the runway during his approach.NTSB CEN09FA364Accident · 1 fatalField investigationFinal reportCessna 150L · Rockwall, TXThe pilot’s failure to maintain aircraft control following a loss of engine power due to contamination in the carburetor. Contributing the severity of the accident was the pilot’s failure to utilize his shoulder harness.NTSB CEN09FA363Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Crystal, MNThe pilot's failure to maintain airspeed which resulted in a loss of aircraft control during a go-around. Factors associated with the accident were the dark night lighting conditions, moderate to heavy rain, and fatigue.NTSB ANC09LA058Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Crooked Creek, AKA total loss of engine power for an undetermined reason.NTSB CEN09CA366Accident · Serious injuriesData collectionFinal reportSabre 2PL · Harrison, NEA loss of directional control for undetermined reasons.NTSB WPR09RA402Incident · No injuriesForeign investigationBoeing 757 · Keflavík, IcelandOn June 15, 2009, a Boeing 757-200, TF-FIA, experienced heat and smoke emanating from the in-flight entertainment system audio jacks, located in two passenger armrests. The incident occurred prior to takeoff from Keflavík International Airport, Reykjanesbaer,…NTSB ERA09WA353Accident · 2 fatalForeign investigationCessna 150 · Urmantany, RussiaOn June 15, 2009, at approximately 0605 universal time coordinated, a Cessna 150L, Russian registration RA-0848G, impacted terrain during a force landing shortly after takeoff. The accident location was approximately 1 kilometer east of Urmantany, in the…NTSB ERA09LA352Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Islesboro, MEA loss of engine power due to fuel contamination.NTSB ERA09CA351Accident · No injuriesData collectionFinal reportDreyer Starduster · Cowlesville, NYA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight fuel inspection.NTSB CEN09LA388Accident · Serious injuriesLimited investigationFinal reportBeech B100 · Rapid City, SDThe flight crewmembers’ failure to secure the patient using the available over-the-shoulder restraints and the encounter with clear-air turbulence during cruise descent.NTSB CEN09CA426Accident · No injuriesData collectionFinal reportCessna A188B · South Haven, MIThe pilot's failure to maintain directional control during landing.NTSB CEN09CA362Accident · No injuriesData collectionFinal reportAirborne Windsports PTY XT-912 · Alamogordo, NMThe failure of the pilot to maintain directional control while landing with gusting winds.NTSB ANC09CA057Accident · No injuriesData collectionFinal reportCessna 180F · King Salmon, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop and substantial damage to the airplane.NTSB WPR09LA287Accident · No injuriesLimited investigationFinal reportHoward Long EZ · Placerville, CAThe pilot's inability to maintain directional control during the landing roll due to a jammed brake cable.NTSB WPR09CA291Accident · No injuriesData collectionFinal reportClarke Colin A Glastar · Wenatchee, WAThe pilot’s failure to maintain adequate airspeed, resulting in an aerodynamic stall and loss of control.NTSB WPR09CA288Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Hell's Canyon, ORThe pilot's failure to maintain clearance from trees.NTSB ERA09LA348Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Fairmont, WVThe pilot’s failure to maintain control of the airplane during takeoff. Contributing to the accident was the pilot's inadequate use of the checklist.NTSB ERA09LA346Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Magee, MSA total loss of engine power after takeoff for undetermined reasons.NTSB ERA09FA345Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Scotia, NYThe flight instructor's failure to ensure that the airplane was properly configured for a short field takeoff, and his decision to not abort the takeoff.NTSB ERA09CA350Accident · No injuriesData collectionFinal reportBeech C17B · Stevensville, MDThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB ENG09IA011Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Diyarbakir, TürkiyeAn uncommanded elevator surface deflection as a result of a left elevator PCU input arm assembly jam due to FOD lodged between the input arm assembly and the PCU housing. The FOD was a roller element from an elevator upper torque tube output crank bearing,…NTSB CEN09LA353Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103C Twin III Acro · Gregory, MIThe pilot's failure to maintain sufficient airspeed during the turn to return for landing, which resulted an inadvertent stall/spin. Contributing to the accident was the failure of the ground winch tow cable shortly after takeoff.NTSB CEN09CA358Accident · Serious injuriesData collectionFinal reportAerostar International RX-9 · Marathon City, WIA hard landing as a result of unexpected high winds and gusts.NTSB CEN09CA357Accident · No injuriesData collectionFinal reportAviat A1 · Garrison, MNThe pilot's improper flare, which resulted in a hard landing on the water and subsequent loss of control.NTSB WPR09LA286Accident · Serious injuriesLimited investigationFinal reportWermling KR-2 Rand Robinson · Anaconda, MTThe non-certificated pilot’s failure to maintain airspeed and aircraft control during initial climb resulting in a stall/spin.NTSB ERA09LA347Accident · No injuriesLimited investigationFinal reportCessna 150H · Lawrenceville, VAA loss of engine power due to carburetor icing.NTSB ERA09LA344Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-6 Twin · Orange, VAThe pilot's improper decision to perform a low-level maneuver over a populated skydive landing area and his inadequate visual lookout.NTSB ERA09FA343Accident · 1 fatalField investigationFinal reportCessna 177 RG · Gilford, NHA loss of engine power due to oil exhaustion from the fracture of the nipple for the engine oil cooler return line. Contributing to the accident was the mechanic's signoff and release of the airplane without performing the required engine run-up following an…NTSB ERA09CA349Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe pilot's failure to maintain control of the helicopter during hover, resulting in a rollover.NTSB ERA09CA342Accident · No injuriesData collectionFinal reportBeech F33A · Rock Hill, SCThe pilot's failure to correctly extend the landing gear before landing.NTSB ERA09CA341Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · West Chester, PAThe student pilot’s improper recovery from a bounced landing. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB ENG09WA013Incident · No injuriesForeign investigationFlorence, ItalyOn June, 13, 2009, a Cimber Air Boeing 737-700 airplane, registered in Denmark as OY-MRG, had the left engine, a CFMI CFM56-7B22, flameout on approach to the Florence, Italy airport. The investigation of this incident is under the jurisdiction of the Agenzia…NTSB WPR09CA289Accident · No injuriesData collectionFinal reportCessna 150 · Nampa, IDThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll.NTSB WPR09CA285Accident · No injuriesData collectionFinal reportCessna 175A · Polacca, AZThe pilot’s failure to adequately estimate the required distance to avoid obstructions while taking off from a road.NTSB ERA09LA339Accident · No injuriesLimited investigationFinal reportPilatus PC-12/47 · Bridgeport, CTThe flight crew's misjudgment of speed and distance, which resulted in an overrun of the wet runway.NTSB ENG09WA021Incident · No injuriesForeign investigationBoeing 737 · Marrakesh Airport, MoroccoOn June 12, 2009, at 0502 UTC, a Boeing 737-400, Morrocan registration CN-RMX, operated by Atlas Blue, fractured a right main landing gear upon landing on runway 28 at Marrakesh Airport. The number 3 main wheel separated. The airplane was on a scheduled…NTSB CEN09LA355Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Cordova, ILThe pilot’s failure to maintain clearance with terrain after clearing an obstacle during an agricultural application pass.NTSB CEN09CA616Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Clark, SDThe pilot's inadequate visual lookout and failure to maintain clearance from a levy.NTSB CEN09CA361Accident · No injuriesData collectionFinal reportAir Tractor AT-402A · Trumann, ARThe pilot's failure to maintain aircraft control in flight. Contributing to the accident was his decision to fly with known hazardous weather conditions in the vicinity.NTSB CEN09CA354Accident · Serious injuriesData collectionFinal reportThrockmorton Matthew E F1-EVO · Mitchell, INA total loss of engine power due to the disconnection of an oil line and the subsequent loss of engine oil.NTSB CEN09CA352Accident · No injuriesData collectionFinal reportAviat A-1A · Marfa, TXThe pilot's failure to maintain control while landing in gusty winds.NTSB CEN09CA351Accident · No injuriesData collectionFinal reportBell 206B · Justin, TXThe instructor pilot's failure to add sufficient power early enough to compensate for the strong gusting headwinds.