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 WPR23LA241Accident · No injuriesClass 3 · LimitedFinal reportCessna 172K · Marana, AZA total loss of engine power due to fuel exhaustion.Jun 23, 2023 · N84385 · Substantial damageNTSB ERA23LA275Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Pence Springs, WVA total loss of engine power due to carburetor icing.Jun 23, 2023 · N9543E · Substantial damageNTSB CEN23LA263Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182G · Gunnison, COThe pilot’s improper decision to fly into an area of unsuitable terrain which the airplane was unable to exit, resulting in an aerodynamic stall and subsequent impact with terrain.Jun 23, 2023 · N3289S · DestroyedNTSB CEN23LA262Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Ocean Springs, MSA total loss of engine power during the initial climb due to fuel starvation for undetermined reasons.Jun 23, 2023 · N4307P · Substantial damageNTSB CEN23LA261Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Cedar Creek, MOA seizure of the power takeoff piston due to inadequate maintenance to the lubrication system, which resulted in a lack of oil lubrication and subsequent engine failure.Jun 23, 2023 · UNREG · Substantial damageNTSB CEN23FA257Accident · 1 fatalClass 3 · FieldFinal reportAvid Magnum · Beaver Island, MIThe pilot’s failure to maintain clearance from the water while maneuvering in low visibility conditions due to smoke and haze.Jun 23, 2023 · N103DG · Substantial damageNTSB CEN23LA255Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Westhope, NDThe pilot’s failure to maintain aircraft control that resulted in an impact with terrain after takeoff.Jun 22, 2023 · N7419Z · Substantial damageNTSB WPR23LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Idaho Falls, IDThe pilot’s failure to maintain directional control while landing with a gusting crosswind.Jun 21, 2023 · N3531Y · Substantial damageNTSB WPR23LA235Accident · No injuriesClass 4 · LimitedFinal reportJohn Topliff PA18-200EXP · Truckee, CAThe pilot’s loss of directional control on landing roll out, during variable wind conditions.Jun 21, 2023 · N356AW · Substantial damageNTSB CEN23LA254Accident · Serious injuriesClass 3 · LimitedFinal reportLet L-23 Super Blanik · Gregory, MIThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the glider’s critical angle of attack, leading to an aerodynamic stall during the off-field landing.Jun 21, 2023 · N10BR · Substantial damageNTSB CEN23LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Osceola, IAThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing.Jun 21, 2023 · N3127C · Substantial damageNTSB CEN23LA250Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7EC · Waunakee, WIA total loss of engine power during the initial takeoff climb due to a worn manual fuel primer pump locking mechanism, which resulted in an unlocked primer and an overly rich fuel mixture.Jun 21, 2023 · N80461 · Substantial damageNTSB CEN23LA249Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Mesquite, TXThe pilot’s inability to maintain directional control during the landing roll due to corroded brake caliper pins.Jun 21, 2023 · N9354B · Substantial damageNTSB CEN23FA248Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7CCM · Duluth, MNThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control.Jun 21, 2023 · N308ED · Substantial damageNTSB ERA23LA272Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Wellington, FLWear of the fuel control unit drive shaft and the corresponding fuel pump drive gear, which resulted in the disengagement of the fuel control unit from the fuel pump, a decrease in fuel flow, and a loss of engine power.Jun 20, 2023 · N3069S · Substantial damageNTSB CEN23LA252Accident · No injuriesClass 4 · LimitedFinal reportStarduster II · Norwich, NYThe pilot’s loss of directional control during landing rollout due to interference from the pilot’s foot/shoe with the airplane structure that resulted in a runway excursion and impact with terrain.Jun 20, 2023 · N299KD · Substantial damageNTSB CEN23LA247Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Cedar Lake, INThe failure of the flight instructor to attain/maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the lake.Jun 19, 2023 · N4076H · Substantial damageNTSB ANC23LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Talkeetna, AKA loss of directional control, while landing, due to a flat main landing gear tire.Jun 19, 2023 · N9214C · Substantial damageNTSB ERA23LA271Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Seymore, TNThe flight instructor’s failure to properly configure the wing flaps for a soft-field takeoff on a short runway, which resulted in a runway overrun and collision with trees.Jun 18, 2023 · N12395 · Substantial damageNTSB CEN23LA246Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · College Station, TXThe mechanic’s failure to properly secure the oil suction screen plug during recent maintenance, which resulted in an oil leak and subsequent loss of engine power due to oil starvation.Jun 18, 2023 · N463HP · Substantial damageNTSB CEN23LA245Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Louise, TXThe pilot’s failure to maintain directional control in gusting wind conditions.Jun 18, 2023 · N932SH · Substantial damageNTSB CEN23LA244Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Sturgis, SDThe pilot’s improper timing to initiate beta mode with the propeller and his failure to maintain directional during the full load landing that resulted in a runway excursion. Contributing to the accident was the pilot’s lack of recent experience with…Jun 18, 2023 · N290LA · Substantial damageNTSB ANC23LA043Accident · No injuriesClass 4 · LimitedFinal reportBuck/Crawford/Crawford Christavia MK-1 · Anchorage, AKThe instructor pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a wing impacting a runway light.Jun 18, 2023 · N5075T · Substantial damageNTSB WPR23LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s improper flare, which resulted in a hard landing.Jun 17, 2023 · N28034 · Substantial damageNTSB WPR23LA232Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Rochester, NVA broken fuel line fitting that resulted in a total loss of engine power due to fuel starvation.Jun 17, 2023 · N3508K · Substantial damageNTSB WPR23LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305C (0-1E) · Big Bear City, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.Jun 17, 2023 · N62TX · Substantial damageNTSB ERA23LA291Accident · No injuriesClass 4 · LimitedFinal reportVolato 400 · Dublin, GAThe pilot’s improper landing flare which resulted in a runway undershoot and a hard landing, which substantially damaged the airplane’s firewall.Jun 17, 2023 · PR-ZVL · Substantial damageNTSB ERA23FA270Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Ebensburg, PAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an uncontrolled descent and collision with terrain.Jun 17, 2023 · N7628Y · DestroyedNTSB ENG23LA030Incident · No injuriesClass 3 · LimitedFinal reportGulfstream Aerospace G-IV · Sioux City, IAA No. 2 (right) engine failure due to a spinner fairing separation and subsequent impact with the fan blades that resulted in a midspan fracture of one fan blade. The spinner fairing separated as a result of a fatigue crack that originated from the heat…Jun 17, 2023 · N926TT · Minor damageNTSB CEN23LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 172B · San Angelo, TXA partial loss of engine power due to loose bolts holding the carburetor throttle body to the fuel bowl.Jun 17, 2023 · N7509X · Substantial damageNTSB CEN23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportTipton Kitfox Kitfox IV · Odessa, MOThe pilot’s failure to attain the proper touchdown speed, which resulted in a runway excursion and subsequent nose over.Jun 17, 2023 · N4287Y · Substantial damageNTSB WPR23LA233Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Elko, NVThe pilot’s loss of control after encountering a dust devil during takeoff.Jun 16, 2023 · N8223A · Substantial damageNTSB ERA23LA281Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Indian Trail, NCA loss of control during the landing roll due to a brake failure for reasons that could not be determined based on available evidence.Jun 16, 2023 · N3662Z · Substantial damageNTSB CEN23LA243Accident · No injuriesClass 4 · LimitedFinal reportBeech 95 · Edna, TXThe pilot’s failure to maintain directional control during a precautionary off-field landing.Jun 15, 2023 · N99PL · Substantial damageNTSB CEN23LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401B · Holyoke, COThe pilot's failure to maintain directional control during the landing roll.Jun 15, 2023 · N6106U · Substantial damageNTSB CEN23LA240Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC-65 · Sibley, IAThe pilot’s failure to maintain adequate airspeed on final approach resulting in the airplane inadvertently exceeding the critical angle of attack and entering an inadvertent aerodynamic stall.Jun 15, 2023 · N23679 · Substantial damageNTSB ERA23LA294Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA50 · Wagener, SCThe pilot’s decision to take off from a short, grass runway in gusting wind conditions, resulting in a rejected takeoff and runway excursion.Jun 13, 2023 · OE-DSD · Substantial damageNTSB WPR23FA225Accident · 1 fatalClass 3 · FieldFinal reportCessna R182 · McCall, IDMaintenance personnel's failure to properly torque and inspect the magneto hardware, which resulted in a partial loss of engine power.Jun 12, 2023 · N3138C · Substantial damageNTSB CEN23LA238Accident · No injuriesClass 4 · LimitedFinal reportMooney M10 · Gassville, ARThe pilot’s failure to maintain control of the airplane during takeoff with a quartering tailwind.Jun 12, 2023 · N9523V · Substantial damageNTSB WPR23LA230Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6A · Mimbres, NMThe pilot’s inflight loss of control while landing with wind gusts that resulted in a hard landing and subsequent nose over.Jun 11, 2023 · N60605 · Substantial damageNTSB ERA23FA266Accident · 1 fatalClass 3 · FieldFinal reportWonder Michael S Harmon Rocket · Porter, NYThe pilot’s failure to maintain control of the airplane while initiating a low-altitude aerobatic maneuver, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s high-risk behavior.Jun 11, 2023 · N85TP · Substantial damageNTSB CEN23LA237Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Pratt, KSFuel exhaustion due to the pilot’s inadequate preflight planning.Jun 11, 2023 · N85RB · Substantial damageNTSB WPR23LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna P210N · Olivehurst, CAThe pilot’s failure to extend the landing gear before landing.Jun 10, 2023 · N4761A · Substantial damageNTSB WPR23LA224Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Agness, ORThe pilot’s failure to maintain sufficient airspeed and decision to touch down on the surface of the water, resulting in a nose over.Jun 10, 2023 · N1778C · Substantial damageNTSB WPR23FA223Accident · 2 fatalClass 3 · FieldFinal reportCompagnie Daher TB 30 Epsilon · Apache Junction, AZThe pilot’s controlled flight into the mountainous terrain due to diminished depth perception as a result of the shadowing effect from the sun’s position. Contributing to the accident was the decision by all three pilots to fly low altitude around the…Jun 10, 2023 · N759F · DestroyedNTSB ERA23LA296Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Lumberton, NJThe student pilot’s improper flight control inputs and the flight instructor’s delayed remedial action during takeoff, which resulted in a runway excursion and impact with the runway edge lights.Jun 10, 2023 · N8126X · Substantial damageNTSB ERA23FA265Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · Orangeburg, SCA stuck No. 3 cylinder intake valve, which resulted in a partial loss of engine power and subsequent forced landing.Jun 10, 2023 · N8725A · DestroyedNTSB WPR23LA228Accident · No injuriesClass 4 · LimitedFinal reportBenoit Leclair Rans S-7S · Bryce Canyon, UTThe pilot's failure to maintain control of the airplane during the landing roll and subsequent impact with terrain during go-around.Jun 9, 2023 · N56QC · Substantial damageNTSB WPR23LA227Accident · No injuriesClass 4 · LimitedFinal reportCamille E Patch Calidus · Jerome, IDThe pilot’s failure to maintain directional control during landing, which resulted in rollover.Jun 9, 2023 · N800YA · Substantial damageNTSB CEN23LA235Accident · No injuriesClass 4 · LimitedFinal reportNorth American T-6G · Colorado Springs, COThe pilot’s failure to maintain directional control during landing.Jun 9, 2023 · N16JV · Substantial damage