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 WPR22LA357Accident · No injuriesClass 3 · LimitedFinal reportVashon Ranger R7 · Glendale, AZFailure of the landing gear due to material deficiencies that reduced the strength of the landing gear.Sep 27, 2022 · N151VR · Substantial damageNTSB CEN22LA434Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · McGregor, TXThe flight crew’s failure to ensure the landing gear was down which resulted in a gear up landing and subsequent runway excursion.Sep 27, 2022 · N409ST · Substantial damageNTSB CEN22FA433Accident · 1 fatalClass 3 · FieldFinal reportAirgyro AG915 · Yankton, SDA loss of control while an in-flight fire occurred, which resulted in an impact with terrain. Contributing to the accident was the pilot/builder’s improper engine build procedures.Sep 27, 2022 · N499AG · DestroyedNTSB WPR22LA359Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Mesa, AZThe flight instructor’s failure to maintain control of the helicopter’s rate of descent, resulting in a hard landing.Sep 26, 2022 · N252SC · Substantial damageNTSB WPR22LA356Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Superior, MTThe pilot’s excessive airspeed during a landing, which resulted in a runway overrun and collision with terrain.Sep 26, 2022 · N12113 · Substantial damageNTSB ERA22LA435Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Clearwater, FLThe pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructor’s delayed remedial action.Sep 26, 2022 · N1434T · Substantial damageNTSB ERA22LA434Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Augusta, GAThe failure of the nose landing gear to fully extend and lock into position for reasons that could not be determined, which resulted in its collapse during landing.Sep 26, 2022 · N745EP · Substantial damageNTSB CEN22LA439Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Williston, NDThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a ground loop.Sep 26, 2022 · N93330 · Substantial damageNTSB WPR22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lyman, WAThe pilot’s delayed decision to exit the valley with rising terrain and failure to maintain clearance from trees.Sep 25, 2022 · N7471G · Substantial damageNTSB WPR22LA355Accident · Minor injuriesClass 4 · LimitedFinal reportHartunian Robert Pulsar XP · Big Bear, CAThe pilot’s inability to maintain directional control after landing with an excessive ground speed due to a tailwind which, resulted in a severe shimmy which subsequently damaged a hydraulic brake line.Sep 25, 2022 · N204BH · Substantial damageNTSB ERA22LA436Accident · No injuriesClass 4 · LimitedFinal reportPiper PA60 · Richmond, KYThe pilot’s failure to extend the landing gear prior to landing.Sep 25, 2022 · N711TL · Substantial damageNTSB CEN22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportHibbard Norman E Thorp T-18 · Del Norte, COThe pilot’s loss of airplane control during landing due to a wind gust.Sep 25, 2022 · N18NH · Substantial damageNTSB ANC22LA080Accident · 1 fatalClass 3 · LimitedFinal reportCessna 180A · Skwentna, AKThe failure of the landing gear float due to inadequate maintenance of the floats and corrosion.Sep 25, 2022 · N9728B · Substantial damageNTSB ERA23LA003Accident · Serious injuriesClass 4 · LimitedFinal reportDestiny XLT · Oneonta, ALThe uncertificated pilot’s failure to maintain control of the powered parachute during takeoff.Sep 24, 2022 · N5065Q · Substantial damageNTSB ERA22LA430Accident · Serious injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Buffalo, NYThe pilot’s failure to maintain aircraft control during initial climb after a go-around, which resulted in an aerodynamic stall and spin at low altitude.Sep 24, 2022 · N5619M · Substantial damageNTSB CEN22LA430Accident · No injuriesClass 3 · LimitedFinal reportAgusta AW139 · Houma, LAThe inflight loss of collective control of the helicopter due to thermal damage of a collective control torque tube that abraded with misrouted electrical wiring, which resulted in an electrical short and inflight fire. Contributing to the accident were the…Sep 24, 2022 · N811TA · Substantial damageNTSB ANC22LA081Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Chignik Lake, AKThe pilot’s failure to maintain airplane control during taxi in gusty conditions, which resulted in a nose-over and substantial damage to the rudder and wings.Sep 23, 2022 · N4144E · Substantial damageNTSB ERA22LA428Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Cincinnati, OHThe airplane builder’s installation of incorrect hardware in the control yoke assembly, which resulted in a loss of control during takeoff.Sep 22, 2022 · N2992W · Substantial damageNTSB DCA22LA212Incident · No injuriesClass 3 · LimitedFinal reportAirbus A330-243 · Los Angeles, CAUncommanded movement of the trimmable horizontal stabilizer control wheel for reasons that could not be determined based on the available evidence.Sep 22, 2022 · N393HA · No damageNTSB ERA22LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Ocean City, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind, resulting in the runway excursion and nose over.Sep 21, 2022 · N9359C · Substantial damageNTSB ERA22LA427Accident · 1 fatalClass 3 · LimitedFinal reportNorthwing Design Apache Sport · Southern Shores, NCA loss of aircraft control due to movement of the outer portion of the right wing fabric and displacement of wing ribs for reasons that could not be determined based on the available information.Sep 21, 2022 · N3283N · Substantial damageNTSB WPR22LA353Accident · No injuriesClass 3 · LimitedFinal reportCessna 525B · Pasco, WAThe failure of the pilot to ensure the landing gear was extended before landing. Contributing was the pilot’s failure to fly a stabilized approach, and his configuration of the airplane that prevented activation of the landing gear not extended warning system…Sep 20, 2022 · N528DV · DestroyedNTSB CEN22LA426Accident · No injuriesClass 4 · LimitedFinal reportMossman Michael D Zenair CH 601 HD · Lebanon, INThe loss of lateral/bank control during takeoff due to the pilot’s decision to operate the airplane with a known fuel imbalance.Sep 20, 2022 · N905KM · Substantial damageNTSB WPR22LA362Accident · No injuriesClass 4 · LimitedFinal reportAngus Watt Zenair Stolch 750 · Howe, IDThe pilot’s failure to maintain adequate airspeed during the landing approach, which resulted in an aerodynamic stall.Sep 19, 2022 · N750RH · Substantial damageNTSB ERA22FA426Accident · 2 fatalClass 3 · FieldFinal reportChampion Aeronca 7AC · Bridgeton, NJThe pilot's exceedance of the airplane’s critical angle of attack shortly after takeoff, which resulted in an aerodynamic stall, loss of control, and impact with terrain.Sep 19, 2022 · N2716E · Substantial damageNTSB ANC22LA078Accident · Minor injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 · Egegik, AKThe pilot’s loss of control during takeoff in gusting wind conditions.Sep 19, 2022 · N24BR · Substantial damageNTSB ERA22LA425Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Great Barrington, MAThe student pilot's inadvertent movement of the fuel selector to the OFF position, which resulted in fuel starvation and a total loss of engine power.Sep 18, 2022 · N6076D · Substantial damageNTSB ANC22LA079Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Tok, AKThe pilot’s improper application of the brakes, which resulted in a nose-over and substantial damage to the rudder and wings.Sep 18, 2022 · N92740 · Substantial damageNTSB ERA22LA424Accident · Minor injuriesClass 3 · LimitedFinal reportRockwell International 700 · Sevierville, TNThe total loss of engine power to the twin-engine airplane during final approach due to fuel exhaustion. Contributing to the accident was the pilot’s failure to maintain aircraft control during the approach to land, which resulted in a runway excursion and…Sep 17, 2022 · N700AK · Substantial damageNTSB ERA22FA422Accident · 2 fatalClass 3 · FieldFinal reportWren Ronnie D Titan II · Citra, FLThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain airspeed while recovering from an aerobatic maneuver, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot’s use of…Sep 17, 2022 · N709RD · Substantial damageNTSB CEN22LA425Accident · No injuriesClass 4 · LimitedFinal reportSlipstream Revelation · Delphi, INA loss of engine power due to carburetor icing.Sep 17, 2022 · UNREG · DestroyedNTSB WPR22LA351Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172L · Ventura, CAA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve.Sep 16, 2022 · N7917G · Substantial damageNTSB WPR22FA348Accident · 2 fatalClass 3 · FieldFinal reportTrom Wayne Vans RV6A · Aztec, AZThe total loss of engine power for reasons that could not be determined based on available evidence. Contributing to the accident was the pilot’s decision to turn away from a suitable emergency landing surface, his failure to maintain adequate airspeed as the…Sep 16, 2022 · N646RV · DestroyedNTSB ANC22LA077Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchorage, AKThe pilot’s inadvertent application of the brakes during the landing roll, which resulted in a nose-over and substantial damage to the rudder and wings.Sep 16, 2022 · N2340S · Substantial damageNTSB WPR22LA349Accident · No injuriesClass 3 · LimitedFinal reportBeech M35 · Henderson, NVThe flight instructor’s failure to verify the fuel quantity and improper fuel management, which resulted in fuel starvation and a total loss of engine power.Sep 15, 2022 · N9876R · Substantial damageNTSB ERA22LA420Accident · Minor injuriesClass 4 · LimitedFinal reportYakovlev YAK-55M · Waldo, FLThe pilot’s inadequate preflight fuel planning and preflight inspection of the airplane, which resulted in fuel exhaustion, a total loss of engine power, and the subsequent off-airport landing.Sep 15, 2022 · N307GS · Substantial damageNTSB ERA22FA418Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32 · Afton, VAA catastrophic engine failure due to oil starvation, which resulted in a total loss of engine power at night over mountainous terrain.Sep 15, 2022 · N2104J · DestroyedNTSB ERA22LA423Accident · Serious injuriesClass 4 · LimitedFinal reportKumhyr David B Vans RV-8A · Elberta, ALThe pilot’s failure to maintain an appropriate descent rate during the landing approach, which resulted in a loss of control and subsequent nose over during landing.Sep 14, 2022 · N955DK · Substantial damageNTSB CEN22LA421Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-180 · Broomfield, COA partial loss of engine power due to a collapsed induction hose that blocked engine intake airflow.Sep 14, 2022 · N3713T · Substantial damageNTSB CEN22FA419Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28R-201 · Conway, SCThe mechanic’s failure to install the required gasket on the vacuum pump drive pad in accordance with the maintenance manual, which resulted in oil exhaustion and the subsequent loss of engine power. Contributing to the accident was the Director of…Sep 14, 2022 · N62FC · DestroyedNTSB WPR22FA345Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46 · Seligman, AZThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup.Sep 13, 2022 · N43605 · Substantial damageNTSB ERA22LA413Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Chattanooga, TNA total loss of engine power due to of carburetor ice. Contributing to the accident was the pilot’s failure to apply carburetor heat.Sep 13, 2022 · N388TC · Substantial damageNTSB CEN22LA418Accident · No injuriesClass 4 · LimitedFinal reportZenith CH701 · Stanton, MNThe pilot’s improper landing flare which resulted in a bounced landing and the nose landing gear collapsing.Sep 13, 2022 · N107GM · Substantial damageNTSB CEN22LA427Accident · No injuriesClass 3 · LimitedFinal reportCessna A188A · Canby, MNThe pilot’s failure to maintain airplane control during the landing, which resulted in an overload failure of the tailwheel cross tube and subsequent impact with the runway.Sep 12, 2022 · N2122U · Substantial damageNTSB CEN22FA416Accident · 1 fatalClass 3 · FieldFinal reportPipistrel Italia S R L Sinus 912 LSA · Waller, TXThe pilot’s failure to maintain aircraft control, which led to an aerodynamic stall at an altitude where recovery was not possible.Sep 12, 2022 · N397R · Substantial damageNTSB ERA22LA419Accident · No injuriesClass 4 · LimitedFinal reportAutogyro USA Calidus · Jasper, GAThe pilot’s failure to maintain control of the gyroplane during a touch-and-go landing.Sep 11, 2022 · N451AG · Substantial damageNTSB WPR22LA369Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Maxwell, CAThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion.Sep 10, 2022 · N7550B · Substantial damageNTSB WPR22LA346Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Las Vegas, NVThe pilot’s failure to maintain airplane control during landing in gusting wind conditions.Sep 10, 2022 · N169PS · Substantial damageNTSB WPR22LA340Accident · Minor injuriesClass 3 · LimitedFinal reportBell Helicopter Textron 206L-1 · Banning, CAThe improper attachment of the tail rotor drive shaft to the air conditioner drive pulley without a drive ring, which resulted in the failure of the hardware, a loss of tail rotor drive, and the loss of control of the helicopter followed by a hard landing and…Sep 10, 2022 · N242BH · Substantial damageNTSB ERA22FA405Accident · 1 fatalClass 3 · FieldFinal reportBeech 95-B55 · Hartwell, GAThe pilot’s spatial disorientation and subsequent loss of airplane control following a perceived undetermined problem with the airplane’s gyroscopic instrumentation.Sep 10, 2022 · N3670D · Substantial damage