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 CEN22LA133Accident · No injuriesClass 4 · LimitedFinal reportKitfox 4-1200 · Woodstock, TXThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Feb 27, 2022 · N494KF · Substantial damageNTSB WPR22LA112Accident · Minor injuriesClass 4 · LimitedFinal reportGregory S Miller GM CUB · Monument, ORThe failure of the pilot to maintain directional control during takeoff, which resulted in an impact with a tree.Feb 26, 2022 · N9013F · Substantial damageNTSB WPR22LA111Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Banning, CAThe solo student pilot's improper landing flare and bounced landing, which resulted in a runway excursion and impact with a parked vehicle and hanger.Feb 26, 2022 · N9010H · Substantial damageNTSB ERA22LA144Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-150 · Savannah, GAThe student pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Feb 26, 2022 · N5208W · Substantial damageNTSB WPR22LA114Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 208B · Oceanside, CAThe pilot’s intentional inflight operation of the propeller in beta, which led to an aerodynamic lock, his inability to restore forward thrust, and subsequent collision with terrain.Feb 24, 2022 · N10JA · Substantial damageNTSB WPR22LA107Accident · No injuriesClass 4 · LimitedFinal reportRoss Jonathan RV-8 · Pinon, AZThe pilot's failure to maintain clearance from power lines during low-level flight.Feb 24, 2022 · N207RV · Substantial damageNTSB WPR22FA109Accident · 1 fatalClass 3 · FieldFinal reportDistar CZ D 13/15 SUN Dancer · Boulder City, NVThe pilot’s failure to maintain clearance from powerlines while maneuvering, which resulted in a wire strike and impact with terrain. Contributing to the accident was the pilot’s impairment from alcohol consumption and his use of diphenhydramine before the…Feb 24, 2022 · N588V · DestroyedNTSB ERA22FA137Accident · 2 fatalClass 3 · FieldFinal reportBeech 35 · Hilltown Township, PAThe pilots’ exceedance of the airplane’s critical angle of attack while practicing maneuvers during an instructional flight, which resulted in an aerodynamic stall and and a loss of airplane control.Feb 24, 2022 · N6129V · DestroyedNTSB CEN22FA131Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Fostoria, OHThe pilot’s loss of airplane control in night instrument meteorological conditions during the procedure turn of an instrument approach due to spatial disorientation, which resulted in a collision with terrain.Feb 23, 2022 · N3952W · DestroyedNTSB CEN22LA130Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker 800XP · Aspen, COThe flight crew’s decision to takeoff in tailwind conditions that were consistently above the airplane’s tailwind limitation, which resulted in a runway overrun following an aborted takeoff. Contributing was the flight crew’s use of the instantaneous wind…Feb 21, 2022 · N99AP · Substantial damageNTSB WPR22LA108Accident · No injuriesClass 4 · LimitedFinal reportKitfox S7 · Phoenix, AZThe pilot’s improper landing flare and subsequent failure to maintain directional control of the airplane during landing, which resulted in a runway excursion.Feb 20, 2022 · N1248 · Substantial damageNTSB WPR22LA102Accident · No injuriesClass 4 · LimitedFinal reportDarrell D. Dugger Mustang II · Cheyenne, WYThe pilot’s failure to maintain directional control during the takeoff roll which resulted in an aborted takeoff and collision with terrain.Feb 20, 2022 · N121DD · Substantial damageNTSB WPR22FA101Accident · 1 fatalClass 3 · FieldFinal reportMcdonnell Douglas 500N · Newport Beach, CAThe helicopter’s encounter with unanticipated right yaw during a low-altitude, low-airspeed, tight-radius orbit. Contributing to the accident was the pilot’s distraction during the orbit, which resulted in the loss of control, his fatigue due to his early…Feb 20, 2022 · N521HB · Substantial damageNTSB ERA22LA134Accident · Minor injuriesClass 3 · LimitedFinal reportSpangenberg AR-1KC · Sarasota, FLThe pilot’s improper control input during an aborted takeoff procedure, which resulted in a main rotor blade contacting the vertical stabilizer, a loss of control, and subsequent runway excursion.Feb 20, 2022 · N65PC · Substantial damageNTSB CEN22LA132Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · Crete, NEThe pilot’s failure to maintain control of the airplane during takeoff.Feb 20, 2022 · N6750U · Substantial damageNTSB CEN22LA128Accident · No injuriesClass 3 · LimitedFinal reportRyan L17 · Livingston, ILA total loss of engine power due to fuel injection system contamination from an unknown source.Feb 20, 2022 · N5042K · Substantial damageNTSB WPR22LA110Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL11C-100 · Placerville, CALoss of directional control during landing with a tailwind.Feb 19, 2022 · N800SW · Substantial damageNTSB WPR22LA106Accident · No injuriesClass 4 · LimitedFinal reportMckenzie John P Europa XS · Tucson, AZThe pilot’s improper landing flare, which resulted in a bounced landing.Feb 19, 2022 · N523WS · Substantial damageNTSB WPR22LA105Accident · No injuriesClass 4 · LimitedFinal reportShelton Joseph G S-7 · Buckeye, AZThe pilot’s exceedance of the airplane’s critical angle of attack while on final approach to land which resulted in an aerodynamic stall and hard landing.Feb 19, 2022 · N242K · Substantial damageNTSB WPR22FA100Accident · 1 fatalClass 3 · FieldFinal reportMoynihan Richard D Vans RV-7A · White Hills, AZThe pilot’s improper aerobatic maneuver leading to an airspeed that exceeded the airplane’s design limits, which resulted in rudder flutter and an in-flight breakup.Feb 19, 2022 · N787NV · DestroyedNTSB ERA22LA131Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Miami Beach, FLA loss of engine power due to a stuck valve, which resulted in an autorotation and a hard landing in water.Feb 19, 2022 · N544SB · Substantial damageNTSB CEN22LA127Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger II · Mountain Home, TXThe non-certificated pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.Feb 19, 2022 · N438RN · Substantial damageNTSB WPR22LA104Accident · No injuriesClass 4 · LimitedFinal reportChristopher P Gage Shortfield Explorer · Coeur d'Alene, IDThe pilot’s improper landing flare which, resulted in a bounced landing, loss of airplane control and subsequent nose over.Feb 18, 2022 · N141E · Substantial damageNTSB WPR22LA103Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-65 · Murphy, IDThe pilot's failure to maintain directional control during the landing roll.Feb 18, 2022 · N36430 · Substantial damageNTSB ERA22LA135Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · White Plains, NYThe pilot’s failure to maintain stabilized lateral control during landing in gusty conditions which resulted in a dynamic rollover when the skids contacted the platform unevenly.Feb 17, 2022 · N929WA · Substantial damageNTSB CEN22LA123Accident · Serious injuriesClass 3 · LimitedFinal reportPitts S-1T · Spring, TXThe failure of maintenance personnel to properly connect the throttle cable, which led to the pilot’s inability to control engine power during the initial climb. Contributing to the accident was the pilot’s misjudgment of the headwind during the forced…Feb 17, 2022 · N731FL · Substantial damageNTSB ERA22LA130Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Washington, NCThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.Feb 16, 2022 · N114BR · Substantial damageNTSB ERA22LA128Accident · No injuriesClass 4 · LimitedFinal reportStinson 108 · Pahokee, FLThe student pilot’s incorrect tail wheel takeoff procedure, and the flight instructor’s lack of remedial action, which resulted in a nose over.Feb 16, 2022 · N6493 · Substantial damageNTSB ERA22FA126Accident · 1 fatalClass 3 · FieldFinal reportBeech 58 · Lexington, NCInadequate maintenance, which led to a partial loss of both right and left engine power during takeoff, and the pilot’s subsequent failure to maintain airspeed while maneuvering with one engine at low altitude. Contributing to the accident was the pilot’s…Feb 16, 2022 · N58LF · DestroyedNTSB DCA22FA082Accident · No injuriesClass 3 · FieldFinal reportJoby Aero JAS4-2 · Jolon, CAThe separation of a propeller blade during expansion flight testing that resulted in cascading effects to include the separation of multiple propulsion motor/propeller assemblies and the loss of remote pilot control of the aircraft. Contributing to the…Feb 16, 2022 · N542AJ · Substantial damageNTSB ERA22LA123Accident · No injuriesClass 3 · LimitedFinal reportBritten-Norman BN-2A-9 · Culebra, PRThe flight crew’s failure to arrest the descent rate during the non-standard approach, which resulted in a hard landing and failure of the right-wing structure. Contributing was the flight instructor’s selection of a challenging approach for initial training.Feb 15, 2022 · N821RR · Substantial damageNTSB ERA22LA120Accident · 8 fatalClass 3 · LimitedFinal reportPilatus PC-12/47E · Beaufort, NCThe pilot’s inadequate preflight planning, inadequate inflight monitoring of the airplane’s flight parameters, and his failure to regain control of the airplane following entry into an inadvertent aerodynamic stall. The pilot’s likely spatial disorientation…Feb 13, 2022 · N79NX · DestroyedNTSB CEN22FA119Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Olathe, KSThe unknown emergency that warranted a return to the airport and the airspeed decay which resulted in an aerodynamic stall.Feb 13, 2022 · N2445F · DestroyedNTSB CEN22LA120Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Murphysboro, ILThe pilot’s failure to maintain clearance from power lines during approach for landing.Feb 12, 2022 · N737SY · Substantial damageNTSB CEN22LA118Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · Katy, TXThe pilot’s failure to maintain a proper glidepath while on the final approach segment of the traffic pattern in dark night conditions.Feb 12, 2022 · N201VZ · Substantial damageNTSB ERA22LA132Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · New Bern, NCThe loss of brake pressure on the left brake due to a failed O-ring seal.Feb 11, 2022 · N2509N · Substantial damageNTSB CEN22LA117Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Lincoln, NEThe pilot’s decision to continue the flight with abnormal engine indications and the subsequent failure of the No. 5 cylinder connecting rod for unknown reasons.Feb 11, 2022 · N317KJ · Substantial damageNTSB WPR22LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Carrizozo, NMThe pilot's failure to maintain directional control during the landing roll.Feb 10, 2022 · N4750B · Substantial damageNTSB WPR22FA094Accident · Minor injuriesClass 3 · FieldFinal reportDassault Mirage F1 CR · Glendale, AZA loss of engine power due to fuel exhaustion as result of the failure of maintenance personnel to ensure the airplane was serviced with the correct amount of fuel, the failure of maintenance personnel and the pilot to adequately check the airplane’s…Feb 10, 2022 · N633AX · DestroyedNTSB ERA22LA127Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210N · Honesdale, PAThe pilot’s failure to attain the proper touchdown point, which resulted in a runway overrun and collision with terrain.Feb 10, 2022 · N5276C · Substantial damageNTSB WPR22LA097Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20J · Paradise, CAThe pilot’s failure to maintain a proper glidepath which resulted in a collision with terrain.Feb 9, 2022 · N201VJ · Substantial damageNTSB ERA22LA118Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E4 · Shrewsbury, PAThe pilot’s failure to maintain control during the descent which resulted in a hard landing.Feb 9, 2022 · N64741 · Substantial damageNTSB ERA22LA117Accident · No injuriesClass 3 · LimitedFinal reportHughes 369D · Bel Air, MDA loss of engine power due to bearing failures in the turbine section resulting from a fatigue fracture of the oil supply line that fed oil to the Nos. 6 and 7 bearings. The oil line failure led to rapid deterioration of the bearings from oil starvation.…Feb 9, 2022 · N9159F · Substantial damageNTSB WPR22LA099Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Napa, CAThe loss of engine power for undetermined reasons, which resulted in an off-airport landing on unimproved terrain.Feb 8, 2022 · N9500E · Substantial damageNTSB WPR22LA093Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Chemehuevi Valley, CAThe student pilot’s loss of directional control during takeoff.Feb 8, 2022 · N6496L · Substantial damageNTSB CEN22LA116Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C35 · Shell Knob, MOThe pilot’s failure to maintain airplane control that resulted in an aerodynamic stall during approach and impact with terrain.Feb 8, 2022 · N1908D · DestroyedNTSB WPR22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna T207 · Crane Island, WAThe pilot’s failure to obtain a proper touch down location on a wet grass runway, resulting in a runway overrun and impact with terrain.Feb 7, 2022 · N684S · Substantial damageNTSB ERA22LA124Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Rocky Mount, NCAn inflight collision with a bird, which resulted in substantial damage to the left wing.Feb 6, 2022 · N9382D · Substantial damageNTSB ERA22LA116Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 · Gilbert, SCThe pilot’s improper flap setting, which resulted in a collision with trees during a takeoff attempt from a short grass field.Feb 5, 2022 · N1454Z · Substantial damageNTSB ENG22FA009Incident · No injuriesClass 3 · FieldFinal reportBoeing 737-8K2 · Las Vegas, NVThe fatigue failure of the right main landing gear initiated by liquid metal embrittlement by cadmium at arc burn locations in the outer cylinder tooling hole area. The arc burns were likely the result of operator error during stylus cadmium plating…Feb 4, 2022 · N817SY · Minor damage