NTSB investigations

19,222 cases where NTSB found Aircraft.

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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
  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.

NTSB CEN21LA404Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Delta, COA total loss of engine power that resulted in a forced landing and subsequent noseover. The reason for the total loss of engine power could not be determined based on the available evidence.Sep 3, 2021 · N9114W · Substantial damageNTSB CEN21LA395Accident · 1 fatalClass 3 · LimitedFinal reportKlapp Peter A Klapp KR-2S · Wadsworth, OHA loss of airplane control for a reason that could not be determined based on available information.Sep 3, 2021 · N729PK · DestroyedNTSB WPR21LA337Accident · No injuriesClass 3 · LimitedFinal reportCessna 172E · Enterprise, ORThe fatigue fracture of the nose gear upper torque link, which resulted in the separation of the torque link from the shock strut and a loss of directional control.Sep 2, 2021 · N3965S · Substantial damageNTSB ERA21FA346Accident · 4 fatalClass 2 · FieldFinal reportCessna 560 · Farmington, CTThe pilot-in-command’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane-nose-down pitching moment that prevented the airplane from becoming airborne within the takeoff…Sep 2, 2021 · N560AR · DestroyedNTSB CEN21LA399Accident · Serious injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Echo Classic · Cotton Port, LAThe pilot exceeding the airplane’s critical angle of attack, resulting in an aerodynamic stall and subsequent loss of control during go-around after a bounced landing.Sep 2, 2021 · N303TA · Substantial damageNTSB DCA21LA229Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-332 · Seattle, WAThe flightcrew’s failure to set the hydraulic panel correctly during the execution of the pushback checklist, and when the hydraulic panel setting was corrected, that resulted in the airplane coming to a sudden stop and a flight attendant receiving a serious…Sep 1, 2021 · N196DN · No damageNTSB CEN21LA398Accident · No injuriesClass 4 · LimitedFinal reportSegarra Lucas JR Zenith Stoll 701 · Grantsburg, WIThe pilot’s improper landing flare, which resulted in abnormal runway contact and the nose landing gear collapsing.Sep 1, 2021 · N705L · Substantial damageNTSB CEN21LA394Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Dunseith, NDThe pilot’s failure to maintain directional control during an attempted go-around with a strong gusting crosswind.Sep 1, 2021 · C-FMFT · Substantial damageNTSB CEN21LA393Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401B · Storm Lake, IAThe pilot’s failure to maintain adequate airspeed during a landing approach with a tailwind that resulted in a landing overrun and impact with terrain.Sep 1, 2021 · N5081W · Substantial damageNTSB ANC21LA101Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Glennallen, AKThe pilot’s improper landing flare while landing off-airport with a tailwind.Sep 1, 2021 · N8987Y · Substantial damageNTSB ANC21LA080Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Pelican, AKThe pilot’s loss of control while landing on a remote helipad.Aug 31, 2021 · N779DZ · Substantial damageNTSB WPR21LA343Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-24-400 · Fullerton, CAThe pilot’s failure to monitor the environment and maintain a proper glidepath on approach which, resulted in a collision with the airport perimeter fence.Aug 30, 2021 · N8501P · Substantial damageNTSB ANC21LA082Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Soldotna, AKThe pilot’s failure to maintain directional control during landing, which resulted in a ground-loop.Aug 30, 2021 · N3419A · Substantial damageNTSB WPR21FA330Accident · 2 fatalClass 3 · FieldFinal reportCessna TU206F · Bernard, IDThe pilot’s decision to continue the flight into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees an terrain.Aug 28, 2021 · N922MA · Substantial damageNTSB ERA21LA345Accident · No injuriesClass 4 · LimitedFinal reportMaule MXT-7-180 · Troy, ALThe pilot's failure to maintain directional control while landing which resulted in a collision with terrain.Aug 28, 2021 · N32566 · Substantial damageNTSB ERA21LA344Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Spartanburg, SCThe flight instructor’s improper fuel management, which resulted in fuel starvation and a total loss of engine power.Aug 28, 2021 · N3862W · Substantial damageNTSB CEN21LA390Accident · Minor injuriesClass 3 · LimitedFinal reportMantooth Thorp T-18 · San Antonio, TXThe loss of engine power after takeoff for undetermined reasons.Aug 28, 2021 · N78DW · Substantial damageNTSB ANC21LA077Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Nikolai, AKThe pilot’s loss of control on go-around in gusting crosswind conditions. Contributing to accident was the pilot’s decision to attempt to land at a short off-airport landing site with a malfunctioning airspeed indicator.Aug 28, 2021 · N2579M · Substantial damageNTSB ANC21LA076Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Kenai, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions which resulted in a loss of control and impact with terrain.Aug 28, 2021 · N82064 · Substantial damageNTSB WPR21LA333Accident · Serious injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206L-1 · Glide, ORThe pilot’s failure to maintain clearance from a tree during an aerial application.Aug 27, 2021 · N303AE · Substantial damageNTSB CEN21LA449Accident · No injuriesClass 4 · LimitedFinal reportColumbia Aircraft Mfg LC41-550FG · Granby, COThe pilot’s loss of control during landing in high density altitude conditions.Aug 27, 2021 · N522LG · Substantial damageNTSB CEN21LA389Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Arnaudville, LAThe loss of tail rotor drive due to a fatigue failure of the tail rotor gearbox output shaft, which resulted in a loss of control during landing.Aug 27, 2021 · N827SH · Substantial damageNTSB ERA21LA389Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Fairfield, NJThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.Aug 26, 2021 · N472CD · Substantial damageNTSB CEN21LA392Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Olive Branch, MSThe pilot’s failure to maintain directional control of the airplane during landing with a direct crosswind that resulted in an impact with terrain.Aug 26, 2021 · N12573 · Substantial damageNTSB CEN21LA386Accident · No injuriesClass 3 · LimitedFinal reportAcro Sport II · Fishers, INThe airplane’s total loss of engine power due to fuel exhaustion as a result of leaking fuel from a loose fuel inlet fitting to the fuel control unit.Aug 25, 2021 · N169BF · Substantial damageNTSB WPR21LA326Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Del Mar, CAThe partial loss of engine power for reasons that could not be determined, which resulted in a forced landing on an interstate highway and subsequent collision with vehicles.Aug 24, 2021 · N2843T · Substantial damageNTSB ERA21LA338Accident · No injuriesClass 3 · LimitedFinal reportSchmitt Just Acft Highlander · Crittenden, KYThe pilot’s inadequate fuel planning, which resulted in fuel starvation and a total loss of engine power.Aug 24, 2021 · N101KL · Substantial damageNTSB DCA21LA208Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-990ER · SeaTac, WAThe passenger’s use of the evacuation slide resulted in the serious injury.Aug 24, 2021 · N479AS · No damageNTSB CEN21LA383Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Gypsum, COA loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.Aug 24, 2021 · N46MD · Substantial damageNTSB CEN21LA382Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Granbury, TXThe loss of engine power for reasons that could not be determined with the available information.Aug 24, 2021 · N67CW · Substantial damageNTSB WPR21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Hayward, CAThe pilot's improper landing flare, which resulted in a bounced hard landing.Aug 23, 2021 · N737GL · Substantial damageNTSB ERA21LA339Accident · No injuriesClass 3 · LimitedFinal reportEnstrom 280 · Port Orange, FLThe failure of the tail rotor drive shaft at the coupling due to torsionally applied shear stress.Aug 21, 2021 · N9285 · Substantial damageNTSB ERA21LA337Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV7 · Mount Holly, NJThe pilot’s improper recovery from a bounced landing, resulting in a touchdown on the nose gear first, resulting in damage to the nose gear and a runway excursion.Aug 21, 2021 · N838WT · Substantial damageNTSB CEN21LA378Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Gonzales, LAThe pilot’s inadvertent collision with a tree while landing at night which resulted in a hard landing.Aug 21, 2021 · N222VB · Substantial damageNTSB CEN21FA377Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Fort Worth, TXThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s inadequate preflight planning, which resulted in an exceedance of the airplane’s…Aug 21, 2021 · N1472E · Substantial damageNTSB ANC21LA094Accident · No injuriesClass 3 · LimitedFinal reportDehavilland DHC-3 · Bettles, AKThe seizure of the engine during flight for undetermined reasons, which led to a total loss of engine power.Aug 21, 2021 · N560TR · Substantial damageNTSB ANC21LA081Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Kodiak, AKThe pilot’s improper landing flare, which resulted in a hard landing and nose over.Aug 21, 2021 · N4334Y · Substantial damageNTSB WPR21LA328Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wasilla, AKThe pilot’s inability to maintain control of the airplane during taxi after it encountered the prop wash from a larger airplane that was conducting a high-power engine run on the same taxiway.Aug 20, 2021 · N89ZW · Substantial damageNTSB ERA21FA334Accident · 1 fatalClass 3 · FieldFinal reportNorth American SNJ-2 · Wilkes-Barre, PAA partial loss of engine power for undetermined reasons. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for a forced landing following the loss of engine power, which resulted in an aerodynamic stall and…Aug 20, 2021 · N52900 · DestroyedNTSB ERA21FA333Accident · 2 fatalClass 3 · FieldFinal reportPiper PA24 · Wadesboro, NCA partial loss of engine power during takeoff for reasons that could not be determined. Contributing was the pilot’s loss of airplane control, resulting in an aerodynamic stall and impact with trees and terrain.Aug 20, 2021 · N8262P · DestroyedNTSB CEN21LA385Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · New Roads, LAA loss of engine power for reasons that could not be determined due to a lack of available evidence.Aug 20, 2021 · N744RB · DestroyedNTSB CEN21FA376Accident · 1 fatalClass 3 · FieldFinal reportSocata TBM 700 · Urbana, OHThe pilot’s failure to arrest the airplane’s left roll and rapid descent for reasons that could not be determined based on the available evidence.Aug 20, 2021 · N700DT · DestroyedNTSB CEN21LA397Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · New Braunfels, TXThe pilot’s failure to maintain control of the airplane during landing.Aug 19, 2021 · N55245 · Substantial damageNTSB ERA21LA335Accident · No injuriesClass 3 · LimitedFinal reportHummer 260L · Livingston, TNA total loss of engine power for reasons that could not be determined. Contributing to the accident was the pilot’s operation of the helicopter in a flight regime that would not allow for a successful autorotative landing.Aug 18, 2021 · N777TC · Substantial damageNTSB ERA21LA332Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec 162 · Lindale, GAThe pilot's improper judgment of the helicopter’s height above ground during the landing flare, which resulted in a hard landing with forward airspeed and subsequent bounce and rollover.Aug 18, 2021 · N162LR · Substantial damageNTSB ERA21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Louisville, KYA loss of directional on takeoff for reasons that could not be determined.Aug 18, 2021 · N62LU · Substantial damageNTSB ERA21LA328Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Orlando, FLA total loss of engine power due to fuel starvation that resulted from improper maintenance of the fuel selector valve and fuel selector valve cover.Aug 17, 2021 · N98304 · Substantial damageNTSB CEN21LA379Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Industries DA-42 · Bellefontaine, OHThe improper position of the right engine’s fuel feed pump bolt, which led to a total loss of power on the right engine, and the left engine's partial loss of engine power for reasons that could not be determined based on the available evidence.Aug 17, 2021 · N215BN · Substantial damageNTSB WPR21LA325Accident · No injuriesClass 3 · LimitedFinal reportStout Garry V Europa - Trigear · Hanksville, UTThe pilot’s installation of a non-original equipment manufactured radiator cap, which resulted in the loss of coolant and the engine’s exceedance of the maximum admissible cylinder head temperature. Contributing to the accident was the lack of suitable…Aug 16, 2021 · N133AC · Substantial damageNTSB WPR21FA321Accident · 3 fatalClass 3 · FieldFinal reportCessna 182H · Bountiful, UTThe decision of both pilots to fly into a steep canyon, which resulted in the airplane being unable to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was their delayed initial action in responding to the hazard, and their…Aug 16, 2021 · N8477S · Destroyed