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 WPR25LA009Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Mesa, AZThe pilot receiving instruction’s failure to maintain airspeed during landing and the flight instructor’s delayed remedial action, which resulted in a hard landing.Oct 2, 2024 · N4199M · Substantial damageNTSB ANC25LA031Accident · No injuriesClass 4 · LimitedFinal reportLawrence M Zubel Loehle 5151 Mustang · Vernal, UTThe pilot’s improper landing flare, which resulted in a hard, bounced landing which result in the left landing gear collapsing.Oct 2, 2024 · N579LZ · Substantial damageNTSB WPR25LA012Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Soda Springs, IDThe passenger’s inadvertent application of brakes during landing which resulted in a nose over.Oct 1, 2024 · N5636D · Substantial damageNTSB CEN25LA002Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402A · Moffett, OKThe tail wheel assembly’s fractured bolt which resulted in the pilot’s loss of directional control during landing.Oct 1, 2024 · N45472 · Substantial damageNTSB CEN25LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Englewood, COThe collapse of the right main landing gear during landing rollout.Oct 1, 2024 · N756JY · Substantial damageNTSB CEN24LA378Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Caro, MIA total loss of engine power due to maintenance personnel’s failure to properly tighten the fuel supply line B-nut at the fuel servo.Sep 30, 2024 · N31407 · Substantial damageNTSB CEN24LA377Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Manvel, TXThe pilot’s improper recovery from a practice autorotation which resulted in a hard landing. Contributing to the accident was the instructor’s inadequate supervision of the pilot receiving instruction.Sep 30, 2024 · N8372F · Substantial damageNTSB CEN24LA376Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Pierz, MNThe pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.Sep 30, 2024 · N2032M · Substantial damageNTSB ERA24LA401Accident · No injuriesClass 4 · LimitedFinal reportRemos Gemini Remos G-3/600 · Atwell, NYThe pilot’s failure to maintain aircraft control on takeoff.Sep 29, 2024 · N5625T · Substantial damageNTSB CEN24LA375Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14 19 · Cortez, COThe pilot’s failure to extend the landing gear before landing.Sep 29, 2024 · N8851R · DestroyedNTSB ERA24FA397Accident · 5 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Kill Devil Hills, NCThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around attempt, which resulted in an aerodynamic stall and loss of airplane control.Sep 28, 2024 · N1281F · DestroyedNTSB WPR24LA322Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Paris, IDThe pilot’s failure to properly configure the flaps, which resulted in a loss of directional control during takeoff.Sep 27, 2024 · N916PH · Substantial damageNTSB WPR24FA313Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Provo, UTThe pilot's exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and loss of control.Sep 27, 2024 · N831AZ · Substantial damageNTSB CEN24LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 210-5(205) · Bryan, TXThe pilot’s failure to maintain aircraft control during the landing.Sep 27, 2024 · N205CT · Substantial damageNTSB CEN24LA369Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Custer, SDThe balloon landing in increased wind, which resulted in a hard landing and the serious injury of a passenger.Sep 27, 2024 · N605KD · No damageNTSB WPR24LA319Accident · No injuriesClass 3 · LimitedFinal reportBell 206L · Fern Prairie, WAAn aeroelastic interaction between the helicopter’s main rotor blades and nodal beam system, which resulted in oscillations that exceeded the design limits of the tailboom. Contributing to the accident was the failure of the main rotor blade manufacturer to…Sep 26, 2024 · N9984K · Substantial damageNTSB WPR24LA315Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172P · Kooskia, IDThe pilot’s decision to descend into a canyon that exceeded the performance capabilities of the airplane, which resulted in an impact with trees and terrain.Sep 26, 2024 · N54829 · Substantial damageNTSB CEN24LA370Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Muskogee, OKThe pilot’s inattention to refueling during turn-around operations which resulted in a loss of engine power due to fuel exhaustion.Sep 26, 2024 · N6548Z · Substantial damageNTSB ERA24FA395Accident · 2 fatalClass 3 · FieldFinal reportEvolution Revo · Zephyrhills, FLThe flight instructor’s failure to ensure the haul back cable was securely connected to the “J” hook prior to departing on the accident flight, which resulted in the cable becoming disconnected and the wings folding up during flight.Sep 25, 2024 · N889HT · DestroyedNTSB CEN24LA367Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Lakeway, TXThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and loss of control during a go-around.Sep 25, 2024 · N565CP · Substantial damageNTSB CEN24LA379Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Janesville, WIThe student pilot’s improper flare and the flight instructor’s delayed remedial action that resulted in a hard, bounced landing.Sep 24, 2024 · N281EA · Substantial damageNTSB ANC24FA102Accident · 1 fatalClass 3 · FieldFinal reportCessna 206 · Chalkyitsik, AKA loss of engine power due to water-contaminated fuel as a result of the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to ensure replacement filters were available for use during refueling operations.Sep 24, 2024 · N8255Q · Substantial damageNTSB WPR24LA311Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC11 · Grand View, IDThe pilot’s loss of control after encountering a dust devil during taxi.Sep 23, 2024 · N30YC · Substantial damageNTSB ERA24LA393Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ravenel, SCThe pilot’s failure to maintain clearance from terrain, which resulted in the right skid contacting the ground and a subsequent rollover.Sep 23, 2024 · N153LA · Substantial damageNTSB ERA24LA392Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · LaGrange, GAImproper manufacture of a cylinder exhaust valve guide by the engine manufacturer, which resulted in a stuck exhaust valve and a partial loss of engine power during initial climb.Sep 23, 2024 · N4298V · Substantial damageNTSB ERA24FA391Accident · 1 fatalClass 3 · FieldFinal reportAviat S-1-11B · Chapmansboro, TNThe pilot’s loss of airplane control while performing an aerobatic maneuver, which resulted in the airplane entering an inverted flat spin at an altitude too low for recovery.Sep 23, 2024 · N5111B · Substantial damageNTSB WPR24LA316Accident · No injuriesClass 3 · LimitedFinal reportAviat A-1A · Taft, CAThe pilot receiving instruction’s failure to maintain directional control during landing roll and the flight instructor’s delayed remedial action.Sep 22, 2024 · N56TA · Substantial damageNTSB WPR24FA309Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Lancaster, CAThe CJ-6A pilot’s failure to maintain separation and the Yak pilot’s failure to monitor the other airplane during a detachment, which resulted in a midair collision.Sep 22, 2024 · N313YK · 2 aircraft · Substantial damageNTSB ERA24LA389Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Erie, PAThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing and the flight instructor’s inadequate remedial action.Sep 22, 2024 · N61232 · Substantial damageNTSB WPR24LA312Accident · No injuriesClass 4 · LimitedFinal reportConner Michael A Vans Acft RV-9 · Yellow Pine, IDThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an impact with a fence.Sep 21, 2024 · N448MT · Substantial damageNTSB CEN24LA363Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox IV 1200 Spdst · Cleburne, TXThe pilot’s failure to maintain aircraft control, which resulted in an aerodynamic stall and impact with terrain.Sep 21, 2024 · N16KR · Substantial damageNTSB ANC24LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Bettles, AKThe pilot’s failure to adequately compensate for shifting wind conditions, resulting in a hard landing.Sep 21, 2024 · N808PT · Substantial damageNTSB ERA24LA388Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172K · Spartanburg, SCMaintenance personnel’s failure to follow the engine manufacturer’s maintenance guidance, which resulted in the assembly of the engine with an obstructed oil passage, a subsequent lack of lubrication to the front main bearing, and a total loss of engine power.Sep 20, 2024 · N7037G · Substantial damageNTSB ERA24LA387Accident · Minor injuriesClass 3 · LimitedFinal reportAgustawestland Philadelphia AW119MKII · Canandaigua, NYThe pilot’s excessive descent rate during the final approach for landing and his delayed recovery attempt, resulting in a hard landing.Sep 20, 2024 · N281MC · Substantial damageNTSB CEN24LA366Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Ackerman, MSThe excessive airplane speed during a no-flap landing, and the pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun. Contributing to the accident was the interference of the instrument panel wiring with the flight control…Sep 20, 2024 · N73154 · Substantial damageNTSB CEN24LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lincoln, NEThe student pilot’s failure to maintain directional control during landing.Sep 20, 2024 · N259GF · Substantial damageNTSB CEN24LA360Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Shakopee, MNThe pilots’ failure to apply carburetor heat during the descent, which resulted in a loss of power on both engines due to carburetor ice.Sep 20, 2024 · N2083D · Substantial damageNTSB WPR24LA314Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206G · West Sacramento, CAFailure of the No. 4 cylinder fuel injection assembly tube and subsequent total loss of engine power.Sep 19, 2024 · N6522Z · Substantial damageNTSB ERA24LA390Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172K · Fredericksburg, VAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.Sep 19, 2024 · N7058G · Substantial damageNTSB CEN24LA374Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CCX-2000 · Kremmling, COThe pilot’s failure to maintain directional control of the airplane during an aborted landing.Sep 19, 2024 · N822TL · Substantial damageNTSB CEN24LA359Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Italia S R L Virus SW · Boulder, COThe pilot’s improper landing flare, which resulted in a nose down attitude and subsequent porpoised landing.Sep 19, 2024 · N202MM · Substantial damageNTSB ERA24LA385Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Dyersburg, TNFailure of the tailwheel strut, which resulted in a loss of directional control during landing roll and a runway excursion.Sep 18, 2024 · N195KW · Substantial damageNTSB ERA24LA386Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Boston, MAThe failure of a solid hydraulic fluid line, which resulted in a loss of hydraulic fluid that prevented the landing gear extension process from completing normally. Contributing to the outcome was the pilot’s failure to fully activate the emergency landing…Sep 17, 2024 · N18VV · Substantial damageNTSB ANC24LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · McKinley Village, AKThe pilot’s late decision to go-around, failure to maintain proper airspeed, and his exceedance of the airplane’s critical angle of attack which resulted in an aerodynamic stall at too low of an altitude to recover.Sep 17, 2024 · N3474C · Substantial damageNTSB WPR24LA307Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Basin, MTThe pilot’s decision to continue performing a high-performance takeoff in a full throttle and low-rotor-rpm condition, which resulted in a loss of control and subsequent impact with terrain.Sep 15, 2024 · N233WT · Substantial damageNTSB ERA24LA383Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Carrollton, OHA failure of the left main landing gear due to fatigue cracking, which resulted the airplane’s left wing contacting the ground.Sep 15, 2024 · N801JH · Substantial damageNTSB ANC24LA100Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot's excessive braking during the landing roll, resulting in a ground loop and nose over.Sep 15, 2024 · N4118Z · Substantial damageNTSB ANC24LA099Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Skwentna, AKThe pilot’s failure to maintain directional control of the airplane during taxi in gusting wind conditions.Sep 15, 2024 · N2466H · Substantial damageNTSB ANC24LA098Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with obstacles and a subsequent aerodynamic stall.Sep 15, 2024 · N4242Z · Substantial damageNTSB ERA24LA380Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Baltimore, MDThe undetected worn internal parts of the on-condition carburetor, which restricted movement of the float, resulting in fuel starvation. Contributing to the severity of the accident was the pilot’s delayed reduction of the throttle when performing a forced…Sep 14, 2024 · N6FT · Substantial damage