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 GAA20CA092Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportscruiser · Lamar, COThe pilot's distraction due to an open canopy during final approach, which resulted in a loss of altitude and ground impact short of the runway.Nov 23, 2019 · N595SC · Substantial damageNTSB ERA20LA044Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E35 · Okeechobee, FLThe separation of the throttle control cable from the carburetor throttle control lever resulting in the near total loss of engine power. Contributing to the separation of the throttle cable was the lack of proper securing hardware by unknown maintenance…Nov 23, 2019 · N3315C · DestroyedNTSB CEN20CA033Accident · No injuriesData collectionFinal reportPiper PA18 · Kerrville, TXThe pilot’s loss of airplane control during the landing flare, which resulted in a loss of directional control and ground-loop.Nov 23, 2019 · N530AK · Substantial damageNTSB CEN20CA026Accident · No injuriesData collectionFinal reportBellanca 1730 · Clear Lake, MNThe pilot's focus inside the cockpit during the base turn and final approach, which led to a high sink rate developing and a subsequent hard landing short of the runway.Nov 23, 2019 · N28037 · Substantial damageNTSB CEN20LA020Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus SR22 · Tyler, TXA total loss of engine power as a result of detonation due to a combination of improper magneto to engine timing and a rich fuel mixture.Nov 22, 2019 · N969JM · Substantial damageNTSB GAA20CA090Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Brogue, PAThe pilot's failure to see and avoid wires during approach to landing.Nov 19, 2019 · N71707 · Substantial damageNTSB ERA20LA038Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · College Park, MDThe pilot’s improper flare, which resulted in a bounced landing, his improper airplane configuration during the attempted go-around, which resulted in the airplane not climbing, and his subsequent landing off the side of the runway.Nov 18, 2019 · N1031M · Substantial damageNTSB GAA20CA089Accident · No injuriesData collectionFinal reportCessna 172 · DuBois, PAThe pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his subsequent improper landing flare, which resulted in a hard, bounced landing. Contributing to the accident were the pilot's improper preflight…Nov 17, 2019 · N683SP · Substantial damageNTSB GAA20CA081Accident · No injuriesData collectionFinal reportStinson SR9 · West Jefferson, OHThe pilot's use of excessive braking during landing, which resulted in a nose-over.Nov 17, 2019 · N18416 · Substantial damageNTSB ERA20CA036Accident · Minor injuriesData collectionFinal reportPiper PA32 · Venice, FLA stuck brake caliper, which overheated while the pilot was taxiing the airplane, caught fire, and subsequently destroyed the airplane.Nov 17, 2019 · N5909V · DestroyedNTSB WPR20LA026Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Livermore, CAThe improper installation of the flight control stick, which resulted in separation of the flight control stick from the stick stub assembly and an uncontrolled descent and impact with terrain.Nov 16, 2019 · N8589D · Substantial damageNTSB WPR20LA025Accident · No injuriesClass 3 · LimitedFinal reportNorth American SNJ-4 · Heber City, UTThe pilot’s loss of directional control during landing as a result of the separated tailwheel-to-rudder link rodNov 16, 2019 · N694US · Substantial damageNTSB GAA20CA086Accident · No injuriesData collectionFinal reportCessna 152 · Sherman/Dennison, TXThe pilot's improper landing flare, which resulted in a bounced landing.Nov 16, 2019 · N4705Q · Substantial damageNTSB ENG20IA005Incident · No injuriesClass 3 · IncidentFinal reportAgusta A109 · Penobscot, MEFatigue fracture of the main rotor blade tip cap leading edge and subsequent partial separation of the tip cap, resulting in increased vibrations in the main rotor.Nov 16, 2019 · N901EM · Minor damageNTSB ERA20LA039Accident · No injuriesClass 3 · LimitedFinal reportRans Rans S7 Courier · West Liberty, KYThe pilot's failure to verify that the engine oil tank contained adequate oil for the cross-country flight, which resulted in a total loss of engine power as a result of lack of lubrication. Contributing to the accident was the incorrect oil consumption…Nov 15, 2019 · N831RS · Substantial damageNTSB GAA20CA087Accident · No injuriesData collectionFinal reportFisher FP 202 Koala · Erwin, NCThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with vegetation.Nov 14, 2019 · N47CV · Substantial damageNTSB ERA20LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Toms River, NJThe failure of the Cessna 172N pilot to see and avoid a second airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the Cessna 172N pilot to tune his radio to the correct…Nov 13, 2019 · N3958S · 2 aircraft · Substantial damageNTSB GAA20CA074Accident · No injuriesData collectionFinal reportCessna 172 · FallBrook, CAThe student pilot's use of excessive ground speed while making a right turn when exiting the runway, which resulted in a loss of directional control and a runway excursion.Nov 12, 2019 · N3803S · Substantial damageNTSB GAA20CA071Accident · No injuriesData collectionFinal reportCessna 182 · San Luis, COThe pilot's improper pitch attitude during landing on rising terrain in flat light conditions, which resulted in a hard landing.Nov 12, 2019 · N91846 · Substantial damageNTSB GAA20CA067Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.Nov 12, 2019 · N739UA · Substantial damageNTSB GAA20CA070Accident · No injuriesData collectionFinal reportCessna 195 · Kalispell, MTThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the left main landing gear collapsing.Nov 11, 2019 · N195BG · Substantial damageNTSB GAA20CA072Accident · No injuriesData collectionFinal reportCessna U206 · Mexico, MOThe pilot's failure to properly set the parking brake before exiting an operating airplane, which resulted in a runaway airplane and subsequent impact with trees.Nov 10, 2019 · N29173 · Substantial damageNTSB GAA20CA084Accident · No injuriesData collectionFinal reportBeech 55 · Broomfield, COThe pilot's unintentional retraction of the landing gear during the landing roll.Nov 9, 2019 · N6206V · Substantial damageNTSB GAA20CA064Accident · Minor injuriesData collectionFinal reportNew Glasair Sportsman GS-2 · Huntsville, ARThe pilot's failure to maintain proper pitch control during takeoff from a muddy, turf runway and his exceedance of the airplane's critical angle of attack during the initial climb, which resulted in an aerodynamic stall.Nov 9, 2019 · N24EP · Substantial damageNTSB ERA20LA035Accident · No injuriesClass 3 · LimitedFinal reportBeech 55 · Griffin, GAThe pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.Nov 9, 2019 · N686DR · Substantial damageNTSB CEN20LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Houston, TXThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.Nov 9, 2019 · N7703J · Substantial damageNTSB GAA20CA069Accident · No injuriesData collectionFinal reportCessna 180 · Tyler, TXThe pilot's improper wind correction while taking off with a tailwind, which resulted in a runway excursion and subsequent nose-over.Nov 8, 2019 · N9925N · Substantial damageNTSB WPR20FA019Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR22 · Upland, CAThe 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.Nov 7, 2019 · N220MT · DestroyedNTSB GAA20CA062Accident · No injuriesData collectionFinal reportBell 47G · Groveland, FLThe student pilot's improper cyclic input after a reported hydraulic failure, the reason for which could not be determined, and his failure to follow the emergency procedures, which resulted in a hard landing.Nov 7, 2019 · N6746D · Substantial damageNTSB DCA20IA014Incident · No injuriesClass 3 · IncidentFinal reportEmbraer ERJ170 · Atlanta, GAThe captain’s use of his pitch trim switch, which had been placarded inoperative but not deactivated, resulting in the airplane pitching up when the captain was trying to trim down. The trim commands were reversed due to maintenance personnel’s incorrect…Nov 7, 2019 · N117HQ · No damageNTSB GAA20CA073Accident · Minor injuriesData collectionFinal reportSchleicher ASW15 · Waynesville, OHThe glider pilot's improper approach during landing, which resulted in collision with trees.Nov 6, 2019 · N16TD · Substantial damageNTSB WPR20LA032Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Hurricane, UTThe pilot’s failure to ensure that the landing gear was in the fully extended and locked position before landing. Contributing to the accident was the overload of the landing gear circuit for reasons that could not be determined.Nov 4, 2019 · N936TC · Substantial damageNTSB GAA20CA060Accident · No injuriesData collectionFinal reportRobinson R22 · Smoketown, PAThe student pilot's improper cyclic input while hovering and the flight instructor's delayed remedial action, which resulted in a dynamic rollover.Nov 4, 2019 · N8560A · Substantial damageNTSB ERA20TA030Accident · No injuriesClass 3Final reportBeech 76 · Doral, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.Nov 4, 2019 · N6015Z · Substantial damageNTSB ERA20FA031Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · New Bedford, MAPilot impairment due to exposure to carbon monoxide as a result of undetected corrosion and holes in the engine’s left exhaust muffler.Nov 4, 2019 · N714LK · DestroyedNTSB GAA20CA059Accident · No injuriesData collectionFinal reportErcoupe 415 · Greer, SCThe pilot's improper landing flare, which resulted in a hard landing, loss of directional control, and impact with a fence.Nov 3, 2019 · N87173 · Substantial damageNTSB GAA20CA056Accident · No injuriesData collectionFinal reportPitts S1 · Monument Valley, UTThe pilot's failure to maintain directional control during landing after a wing struck vegetation, which resulted in a runway excursion and subsequent ground-loop.Nov 3, 2019 · C-GMEE · Substantial damageNTSB GAA20CA068Accident · No injuriesData collectionFinal reportIcon A5 · Chester, CTThe pilot's failure to maintain a proper approach angle in dark night conditions, which resulted in a collision with treetops and a subsequent hard landing.Nov 2, 2019 · N59WE · Substantial damageNTSB GAA20CA066Accident · No injuriesData collectionFinal reportAmerican AA 5 · Gilbert, SCThe pilot's improper approach path, which resulted in impact with a tree.Nov 2, 2019 · N24AU · Substantial damageNTSB GAA20CA057Accident · No injuriesData collectionFinal reportCub Crafters CC11 · Palmyra, PAThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain lateral control during a go-around, which resulted in impact with a tree.Nov 2, 2019 · N718CC · Substantial damageNTSB ERA20LA037Accident · Serious injuriesClass 3 · LimitedFinal reportMosquito XE · Seffner, FLThe pilot's failure to maintain control of the helicopter while landing, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's lack of helicopter experience.Nov 2, 2019 · UNREG · Substantial damageNTSB GAA20CA053Accident · No injuriesData collectionFinal reportZenair CH701 · Salem, ORThe pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain. Contributing to the accident was the pilot’s improper decision to make his first flight in an airplane he unfamiliar with before waiting for calm winds.Nov 1, 2019 · N102PH · Substantial damageNTSB ERA20LA028Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Odessa, TXA loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel.Nov 1, 2019 · N732JW · Substantial damageNTSB ERA20FA027Accident · 1 fatalClass 3 · FieldFinal reportGrumman OV-1 · Stuart, FLThe pilot’s improper recovery from a low-altitude aerobatic maneuver, which resulted in descent into terrain.Nov 1, 2019 · N10VD · DestroyedNTSB ERA20FA026Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Paducah, KYThe pilot’s failure to fully seat the fuel selector in the proper tank position during the descent for landing, which resulted in fuel starvation and a total loss of engine power.Nov 1, 2019 · N181AG · DestroyedNTSB CEN20LA017Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TB 30 Epsilon · Kalamazoo, MIA total loss of engine power for undetermined reasons, which resulted in an aerodynamic stall during the pilot’s attempted forced landing at low altitude and impact with terrain.Nov 1, 2019 · N50TB · Substantial damageNTSB ERA20FA025Accident · 1 fatalClass 3 · FieldFinal reportVans RV 4 · Middleburg, FLImpact with power lines for reasons that could not be determined based on available evidence.Oct 31, 2019 · N425JW · DestroyedNTSB ERA20FA022Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Ocala, FLThe pilot’s failure to maintain control of the airplane due to an acute medical event and/or his use of impairing medications.Oct 31, 2019 · N959CM · DestroyedNTSB ANC20LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Honolulu, HIThe pilot of the Cessna's failure to set the parking brake before diverting his attention inside the airplane, which resulted in his airplane colliding with the airplane ahead of it on the taxiway.Oct 31, 2019 · N926FE · 2 aircraft · Minor damageNTSB ERA20FA021Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28R · Atlanta, GAThe pilot's loss of control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.Oct 30, 2019 · N56258 · Destroyed