NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ERA22LA018Accident · Serious injuriesClass 3 · LimitedFinal reportZ-Hi-Max 1400 · Benton, PAThe pilot’s loss of control and encounter with an aerodynamic stall during a planned low-altitude turn toward the airport after takeoff.NTSB DCA22WA032IncidentClass 5 · ForeignBoeing 787 · Montevideo, UruguayNTSB WPR22LA019Accident · No injuriesClass 3 · LimitedFinal reportLancair ES · Fall Creek, ORTotal loss of engine power due to fatigue failure of the camshaft gear.NTSB WPR22FA011Accident · 1 fatalClass 3 · FieldFinal reportCessna 175 · Reserve, NMThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude. Contributing to the accident was the pilot’s reduced forward visibility due to the sun.NTSB GAA22WA013Incident · No injuriesClass 5 · ForeignAgusta AB206B · Cleethorpes, United KingdomNTSB ERA22LA017Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Fire Island, NYA total loss of engine power for undetermined reasons.NTSB DCA22WA061Incident · No injuriesClass 5 · ForeignBoeing 737 · Cluj-Napoca, RomaniaNTSB WPR22LA015Accident · Serious injuriesClass 3 · LimitedFinal reportWsk-Mielec AN-2TD · Wilton, CAThe pilot’s inability to control the airplane’s pitch during departure for reasons that could not be determined because of the extensive fragmentation and thermal damage the airplane sustained in the accident sequence.NTSB ERA22LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Inverness, FLThe pilots inadequate recovery from a wind gust during landing, which resulted in a hard landing and substantial damage to the fuselage.NTSB ERA22LA016Accident · Serious injuriesClass 3 · LimitedFinal reportKitfox IV · North Canaan, CTThe pilot's mismanagement of the airplane's altitude, airspeed, and course during a forced landing following a partial loss of engine power, which resulted in collision with trees and terrain. Contributing was the pilot’s inadvertent omission of stowing the…NTSB ERA22FA015Accident · 1 fatalClass 3 · FieldFinal reportVelocity SE RG · Titusville, FLThe separation of the airplane’s elevator control push-pull tube, which resulted in a loss of control during the approach.NTSB WPR22LA014Accident · No injuriesClass 3 · LimitedFinal reportAvid Mark IV · Payette, IDA total loss of engine power during cruise flight due to fuel starvation. Contributing to the accident was the lack of an outlet screen on the fuel system header tank.NTSB ERA22FA014Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-260 · Blairsville, GAThe pilot’s decision to commence the flight in low IFR weather conditions, and making immediate turns after takeoff in IMC, resulting in spatial disorientation and a loss of airplane control.NTSB DCA22WA008Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Hong Kong, Hong Kong SAR ChinaNTSB ANC22LA002Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Chickaloon, AKA mid-air collision for reasons that could not be determined based on the available evidence.NTSB WPR22LA016Accident · No injuriesClass 3 · LimitedFinal reportCessna 180H · Kalispell, MTThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop and a runway excursion.NTSB CEN22FA013Accident · 2 fatalClass 3 · FieldFinal reportNew Glasair Glastar · Waukesha, WIThe noninstrument-rated pilot’s decision to depart and continue flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB WPR22FA004Accident · 2 fatalClass 3 · FieldFinal reportCessna 340A · Santee, CALoss of control due to spatial disorientation.NTSB GAA22WA177Accident · 2 fatalClass 5 · ForeignPiper PA34 · Königswinter, GermanyNTSB ERA22LA073Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Wheeler Heights, GAThe airplane’s impact with a bird while in the traffic pattern.NTSB CEN22FA011Accident · 1 fatalClass 3 · FieldFinal reportBeech 58TC · Mesa, COThe maintenance personnel’s failure to properly tighten the turbocharger oil line and the right engine propeller governor, which resulted in a loss of engine power. Contributing to the accident was the loss of airplane control following the loss of engine…NTSB WPR22LA006Accident · No injuriesClass 4 · LimitedFinal reportBevilacqua Jeffrey L Dragonfly Mkiih · Camarillo, CAThe pilot’s failure to maintain airplane control during takeoffNTSB GAA22WA015Accident · 1 fatalClass 5 · ForeignCavalier SA102.5 · Lacombe-Alberta, CanadaNTSB GAA22WA008Accident · Minor injuriesClass 5 · ForeignCessna 172 · Yapu, ColombiaNTSB ERA22LA011Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Greenville, SCA total loss of engine power resulting from the in-flight disconnection of oil hoses from the oil thermostat.NTSB ERA22FA010Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Cornwall, NYThe non-instrument-rated pilot’s continued flight into deteriorating weather conditions, which resulted in a loss of control due to spatial disorientation.NTSB DCA22WA022IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoNTSB ANC22LA001Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Palmer, AKThe unmanned aircraft pilot’s failure to yield the right of way to the helicopter.NTSB WPR22LA007Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-32 · San Juan Baptista, CAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which necessitated a forced landing.NTSB WPR22LA005Accident · No injuriesClass 3 · LimitedFinal reportBeech B36TC · Los Banos, CAThe total loss of engine power due to the improper installation of the No. 4 connecting rod bolt nut during a recent overhaul.NTSB GAA22WA066AccidentClass 5 · ForeignPiper PA18 · Trevelin, Chubut, ArgentinaNTSB GAA22WA016Accident · No injuriesClass 5 · ForeignRotoway International Executive 162F · Cape Town, South AfricaNTSB GAA22WA011AccidentClass 5 · ForeignAero Commander 100 · Carinthia, AustriaNTSB ERA22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Statesboro, GAThe student pilot’s failure reduce power and apply sufficient braking after landing, which resulted in a runway excursion and impact with objects and terrain.NTSB ERA22LA013Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Fruitland Park, FLThe pilot’s failure to establish a proper landing flare, which resulted in a hard landing.NTSB ERA22LA012Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Winchester, VAThe pilot’s misapplication of brakes during the landing roll which resulted in a nose-over event and substantial damage to the airplane.NTSB ENG22WA039IncidentClass 5 · ForeignBoeing 767 · São Tomé, São Tomé e Príncipe, São Tomé & PríncipeNTSB DCA22LA012Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8H4 · Lexington, VAThe airplane’s inadvertent encounter with convective turbulence.NTSB CEN22LA015Accident · No injuriesClass 4 · LimitedFinal reportZuber Thomas P Zuber Super Drifter · Horseshoe Bay, TXThe pilot’s failure to adequately monitor airspeed during a low-level turn, which resulted in an aerodynamic stall and impact with the water.NTSB CEN22LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Chesterfield, MOThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard, bounced landing and the nose landing gear collapsing. .NTSB ERA22FA009Accident · 4 fatalClass 3 · FieldFinal reportCessna P210 · Atlanta, GAThe pilot’s failure to ensure that his seat was properly secured before initiating the takeoff, which resulted in a loss of control during the initial climb. Contributing to the accident was the lack of an installed secondary seat stop, and the airplane’s aft…NTSB DCA22WA023IncidentClass 5 · ForeignAirbus A320-214 · Ibague, ColombiaNTSB CEN22LA012Accident · Serious injuriesClass 3 · LimitedFinal reportStinson 108 · Wildwood, ARA total loss of engine power for reasons that could not be determined.NTSB WPR22LA009Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Albany, ORThe pilot's failure to maintain directional control during takeoff.NTSB ERA22LA007Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 429 · Batavia, NYThe pilot’s failure to disengage the autopilot prior to climbing out of a fog bank.NTSB CEN22LA010Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24 · Loveland, COThe pilot’s failure to recognize the degraded engine power and abort the takeoff in a timely manner.NTSB CEN22LA008Accident · 1 fatalClass 3 · LimitedFinal reportSea & Sky Krucker Cygnet · Point Venture, TXThe pilot’s abrupt pitch up maneuver in response to the localized wind conditions which resulted in an aerodynamic stall at low altitude and subsequent impact with water.NTSB GAA22WA010Accident · No injuriesClass 5 · ForeignCessna 150 · Rio De Janeiro, BrazilNTSB ERA22LA006Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Williston, FLThe pilot’s failure to maintain clearance from terrain on approach which resulted in controlled flight into trees. Contributing to the accident was the flight instructor’s inadequate supervision of the approach path, the dark night conditions and the landing…NTSB CEN22LA009Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Gonzales, LAThe student pilot’s failure to compensate for an unanticipated right yaw, which resulted in a loss of tail rotor effectiveness and helicopter control.