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 CEN22LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Benton, KSThe loss of engine power for undetermined reasons.NTSB CEN22LA366Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Maynard, IAAn impact with a powerline as a result of an unexpected wind gust.NTSB WPR22LA291Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters AS350B3 · Chino, CAThe subsequent delamination of the main rotor blades as a result of an unidentified main rotor blade impact with vegetation during a previous flight by another pilot.NTSB ERA22LA370Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Shirley, NYThe flight instructor’s failure to ensure clearance from an electrical junction box during takeoff, which resulted in a collision.NTSB ERA22LA356Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182C · Holly Ridge, NCThe pilot’s failure to maintain clearance of powerlines on final approach.NTSB CEN22LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 180C · Cantwell, AKThe pilot's excessive brake application during the landing roll that resulted in a nose over.NTSB CEN22LA368Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182P · Midland, TXThe student pilot’s failure to maintain control of the airplane while landing with gusting wind.NTSB CEN22LA365Accident · No injuriesClass 4 · LimitedFinal reportUltramagic M56C · Indianola, IAThe pilot’s failure to maintain adequate clearance from powerlines.NTSB WPR22LA290Accident · No injuriesClass 3 · LimitedFinal reportEADS Socata TBM 700 · Carlsbad, NMThe pilot’s failure to extend the landing gear before landing due to a distraction, which resulted in an impact with the runway.NTSB ERA22LA357Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Leghighton, PAThe pilot’s improper recovery from a bounced landing on a slope, which resulted in dynamic rollover.NTSB ERA22LA355Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7BCM · Cranberry Township, PAThe pilots’ failure to maintain directional control of the airplane while landing in gusting wind conditions.NTSB ERA22LA352Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Nixon, PAThe pilot’s failure to maintain directional control while landing, resulting in a runway excursion. Contributing to the outcome was the pilot’s failure to ensure that the airplane’s right side door was properly secured prior to departing on the accident…NTSB ERA22FA354Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Cynthiana, KYThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to land with approaching convective activity.NTSB CEN22LA361Accident · No injuriesClass 3 · LimitedFinal reportVans RV-10 · Hurst, ILA loss of engine power for reasons that could not be determined.NTSB CEN22LA359Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Melville, LAThe pilot improperly monitored the operating environment which resulted in a collision with a tree located in the middle of a field.NTSB ANC22LA082Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver U-6A · Kokhanok, AKThe pilot's failure to maintain directional control of the airplane during takeoff operations.NTSB ERA22FA351Accident · 2 fatalClass 3 · FieldFinal reportSmith Aerostar 600 · South Haven Charter Township, MIA loss of power to the left engine due to contamination of the fuel system. Contributing to the accident was the pilots’ failure to properly configure the airplane for flight with one engine inoperative.NTSB ERA22FA350Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502 · Cheneyville, LAThe pilot’s loss of control after exceeding the airplane’s critical angle of attack for reasons that could not be determined.NTSB CEN22LA381Accident · No injuriesClass 4 · LimitedFinal reportPiper PA31 · Port Alsworth, AKA hard landing that occurred at an unknown time and date, which resulted in substantial damage.NTSB ERA22LA349Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Wauchula, FLThe pilot’s failure to maintain directional control after landing. A contributing factor was a degraded left main landing gear wheel assembly.NTSB CEN22LA354Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-301 · Lamoni, IAA loss of airplane performance for reasons that could not be determined.NTSB CEN22LA352Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Washington, LAThe pilot’s failure to maintain clearance from a wire during an aerial application of a field.NTSB CEN22LA351Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206B · Arcadia, IAMaintenance personnel’s failure to properly torque a fuel control unit B-nut, which resulted in a loss of engine power at low altitude and an impact with terrain.NTSB CEN22LA379Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Joliet, ILThe pilot’s inadequate landing flare, which resulted in a hard, bounced landing.NTSB CEN22LA350Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Marshall, MOThe pilot’s failure to adequately survey a field for obstructions prior to a low-level aerial application pass, which resulted in an impact with a powerline.NTSB WPR22LA287Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Livermore, CAThe total loss of engine power due to an inadequately maintained fuel injection servo.NTSB ERA22LA353Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Columbus, OHThe pilot’s improper landing flare, which resulted in a bounced landing and a collapse of the left main landing gear.NTSB ERA22LA346Accident · Serious injuriesClass 3 · LimitedFinal reportTextron G36 · Ridgeland, SCA loss of engine power for reasons that could not be determined.NTSB ERA22LA345Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Ephratah, NYA loss of engine power for undetermined reasons.NTSB ERA22FA344Accident · 2 fatalClass 3 · FieldFinal reportHarvey J Brock Tango 2 · Melrose, FLA loss of control for undetermined reasons.NTSB CEN22LA364Accident · No injuriesClass 4 · LimitedFinal reportBeechcraft 35 · Star City, ARThe pilot’s delayed decision to abort the takeoff, which resulted in a runway excursion and impact with a ditch.NTSB CEN22LA362Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe flight instructor’s failure to properly supervise the student pilot, which resulted in a continued unstablized approach for landing, and the instructor’s delayed recovery that resulted in a loss of control and impact with terrain.NTSB CEN22LA358Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Mecosta, MIThe pilot’s decision to depart on inadequate runway surface conditions that resulted in a loss of control after attempting to abort the takeoff, a runway excursion, and a nose over.NTSB CEN22LA356Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 150A · Indianola, IAThe pilot’s failure to maintain clearance from power lines during low-level maneuvering.NTSB CEN22LA355Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Marshall, TXThe student pilot’s inadequate fuel planning and improper in-flight decision-making which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22FA347Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Ute, IAThe pilot’s inflight collision with a power line during aerial application.NTSB WPR22LA289Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fairbank's, AKThe student pilot's failure to maintain directional control during the takeoff roll.NTSB ERA22LA348Accident · 1 fatalClass 3 · LimitedFinal reportCASA C212 · Raeford, NCThe airplane’s encounter with windshear during landing, which resulted in a hard landing and separation of the right main landing gear, and the pilot’s subsequent decision to leave his seat in flight, which resulted in his fall from the airplane.NTSB ERA22FA343Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter AS350 · Andalusia, ALThe pilot’s acute incapacitation by a syncopal episode, which resulted in the helicopter departing controlled flight and colliding with terrain.NTSB CEN22LA369Accident · No injuriesClass 4 · LimitedFinal reportICP Savannah S · Evansville, INThe pilot’s improper landing flare in gusting winds, which resulted in a hard landing and the nose gear collapsing.NTSB CEN22LA353Accident · Serious injuriesClass 3 · LimitedFinal reportSonex Sonex · River Falls, WIThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA348Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sturgeon Lake, MNThe pilot’s failure to maintain directional control during takeoff from a gravel driveway resulting in an impact with a tree.NTSB WPR22LA288Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McCarthy, AKThe pilot’s improper decision to takeoff from an unimproved airstrip with a high density altitude which degraded its climb performance and led to a collision with vegetation off the end of the airstrip.NTSB ERA22LA358Accident · No injuriesClass 3 · LimitedFinal reportCessna 207 · Dillingham, AKMaintenance personnel’s failure to detect and correct improper rudder control system alignment, the resulting interference with the pulley’s rotation, and the accelerated corrosion and wear of the control cable, which ultimately led to its failure in flight.NTSB CEN22LA372Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-3 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll which resulted in a runway excursion and collision with a ditch.NTSB CEN22LA346Accident · No injuriesClass 4 · LimitedFinal reportMeschler Gary R RV-4 · Oshkosh, WIThe failure of the pilot of N694V (RV-8) to maintain clearance from the preceding airplane, N79KM (RV-4), while taxiing for takeoff, which resulted in an on-ground collision.NTSB CEN22LA345Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ithaca, NEThe pilot’s failure to maintain clearance from power lines during low level aerial application operations due to a distraction.NTSB CEN22LA344Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Dallas, TXMaintenance personnel’s inadequate maintenance of the magneto, which resulted in a loss of engine ignition, a loss of engine power, and a subsequent forced landing.NTSB ANC22LA062Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Anchorage, AKThe pilot’s failure to maintain directional control during the landing rollout in crosswind conditions, which resulted in a runway excursion and impact with equipment.NTSB WPR22LA292Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · San Diego, CAThe student pilot’s unstable approach and inadequate flare which resulted in a hard, bounced landing.