Final 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 WHERE c.\"completionStatus\" = 'Completed' 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 WHERE c."completionStatus" = 'Completed' 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 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 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 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 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 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 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 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 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.NTSB WPR22LA010Accident · Serious injuriesClass 4 · LimitedFinal reportRichardson Andrew P RICHARDSON-75 · Alburquerque, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and serious passenger injury.NTSB ERA22LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Columbia, SCA failure of the landing gear hydraulic power pack for reasons that could not be determined.NTSB ERA22FA004Accident · 2 fatalClass 3 · FieldFinal reportDassault Falcon 20 · Thomson, GAThe flight crew’s continuation of an unstable dark night visual approach and the captain’s instruction to use air brakes during the approach contrary to airplane operating limitations, which resulted in a descent below the glide path, and a collision with…NTSB CEN22LA006Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Delta, MOThe pilot’s inadequate inflight planning and his failure to see and avoid a wire which resulted in contact with the wire and subsequent ground impact.NTSB CEN22LA005Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Houston, TXThe pilot’s improper application of brakes during landing.NTSB WPR22LA008Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Garberville, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent collision with an unoccupied parked airplane.NTSB CEN22LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195 · Watkins, COThe separation of the left main landing gear spring during landing roll due to a preexisting fatigue crack.NTSB ERA22LA002Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Oxford, NCA total loss of engine power due to fuel contamination.NTSB ERA22FA001Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Andrews, NCThe pilot’s decision to fly toward rapidly rising, obscured mountainous terrain after departing under visual flight rules at night.NTSB CEN22LA007Accident · Minor injuriesClass 3 · LimitedFinal reportSoneral L2 · Minot, NDThe pilot’s failure to maintain proper airspeed and exceedance of the airplane’s critical angle of attack on final landing approach, which resulted in an aerodynamic stall and hard landing. Contributing to the accident was the pilot’s inexperience with the…NTSB CEN22LA001Accident · 2 fatalClass 3 · LimitedFinal reportTandem Air-Bike · Warrensburg, MOThe improper judgment of both pilots to attempt a flight while impaired by drugs/medications and their failure to maintain control of the aircraft, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR22LA003Accident · No injuriesClass 4 · LimitedFinal reportInterstate S-1A · Independence, ORThe separation of the left rudder pedal interconnect cable during takeoff, which resulted in the student pilot’s inability to maintain directional control.NTSB WPR22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportZenith CH750 · Oregon City, ORThe total loss of engine power for undetermined reasons.NTSB ERA22LA038Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C 200 · Riverhead, NYThe pilot's excessive braking during landing which resulted in a noseover and substantial damage.NTSB ENG22LA002Incident · Minor injuriesClass 3 · LimitedFinal reportAirbus A320-271N · Atlantic City, NJThe ingestion of a bird into the right engine during the takeoff roll caused a fan blade to fracture near the blade platform resulting in high fan blade off loads and engine vibrations sufficient to result in an eventual failure of a fuel tube in the right…NTSB DCA22LA005Accident · No injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Chicago, ILA ground collision by SkyWest flight 5845 that resulted in substantial damage to Republic Airlines flight 3594.NTSB CEN22LA003Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing PT-17 · Winnie, TXThe pilot’s decision to takeoff from a road with obstacles in his flight path and his failure to maintain control of the airplane when encountering changing winds from approaching thunderstorms which resulted in the airplane impacting signal light cables.NTSB CEN22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B23 · Lamesa, TXThe loss of engine power for a reason that could not be determined.NTSB WPR22FA001Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 · Chandler, AZThe failure of the pilots onboard the airplane to see and avoid the helicopter while maneuvering in the traffic pattern, which resulted in a midair collision.NTSB ERA22LA003Accident · No injuriesClass 4 · LimitedFinal reportCulp John S Culps Specl Sopwith · Pottstown, PAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB WPR21LA359Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Phoenix, AZThe student pilot's failure to maintain helicopter control while making a clearing turn which resulted in a hard landing.NTSB ERA21LA391Accident · No injuriesClass 3 · LimitedFinal reportBoeing E75 · Nicholson, PAA total loss of engine power as a result of damaged internal carburetor mixture control components.NTSB CEN21LA469Accident · Minor injuriesClass 4 · LimitedFinal reportMeuer SA900 V-STAR · Kokomo, INThe pilot’s failure to maintain adequate speed and altitude during final approach, which resulted in an off field landing short of the runway and a subsequent nose over.NTSB ERA21LA394Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Apopka, FLA loss of directional control during landing for reasons that could not be determined based upon the disposition of the wreckage following a late accident report.NTSB ERA21LA390Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · Kinston, NCThe buckling of the tail boom as a result of a hard landing event of undetermined time and location.NTSB ERA21LA388Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Port Orange, FLThe separation of the nut from the stud and the fracture of the bolt that secured the crankshaft idler gear to the engine crankcase, which resulted in a total loss of engine power due to the inability of the left crankshaft idler gear assembly to drive of the…