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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DCA24LA328Incident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Austin, TXThe unintended activation of the Emergency Autoland button on the overhead panel due to the airplane’s collision with an unknown object. Contributing to the incident was the pilot’s inability to initially deactivate the Emergency Autoland system due to a…NTSB ANC24LA097Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-3 · Lime Village, AKThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing in tree-covered terrain.NTSB ANC24LA096Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Buckland, AKThe pilot's failure to maintain directional control during the landing roll.NTSB ANC24FA092Accident · 1 fatalClass 3 · FieldFinal reportJon Bergstedt JP Flyer · Wasilla, AKThe installation of an improperly sized fuel line that did not allow for adequate fuel flow to the engine, resulting in a partial loss of engine power and collision with trees.NTSB ERA24LA381Accident · Minor injuriesClass 4 · LimitedFinal reportWalden Robert Vans Aircraft RV-7A · Williamsburg, VAThe pilot’s decision to continue with an unstabilized approach which resulted in a hard landing and loss of directional control during a subsequent landing.NTSB CEN24LA355Accident · Minor injuriesClass 4 · LimitedFinal reportJust SuperStol · Mount Vernon, IAThe pilot’s failure to maintain airplane control during a go-around which resulted in an aerodynamic stall and collision with terrain.NTSB CEN24LA358Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Canton, MIFatigue cracking of the main rotor blade that occurred at an undetermined time.NTSB CEN24LA354Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170A · Marshall, INThe fatigue fracture of the No. 6 piston connecting rod, which resulted in a loss of engine power.NTSB CEN24LA352Accident · No injuriesClass 4 · LimitedFinal reportJust Highlander · Clarksdale, MSThe pilot’s failure to maintain control during takeoff in gusting crosswind conditions.NTSB CEN24LA351Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Schaumburg, ILThe flight crew’s fuel mismanagement resulting in the loss of engine power due to fuel starvation.NTSB CEN24LA350Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Englewood, COA partial loss of engine power due to fuel-oil contamination of the fuel injection servo.NTSB ERA24LA378Accident · No injuriesClass 4 · LimitedFinal reportBrandt Stirling D WAIEX-B · Stratford, CTThe pilot’s failure to maintain direction control of the airplane during a takeoff in crosswind conditions.NTSB ERA24LA375Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802 · Hickory Valley, TNA partial loss of engine power due to a leak in the fuel control unit bellows, which resulted in the fuel valve moving to minimum fuel flow.NTSB DCA24FA299Accident · Minor injuriesClass 3 · FieldFinal reportAirbus A350-941 · College Park, GADelta Air Lines flight crew’s loss of situation awareness of the clearance between their right wingtip and the empennage of an Endeavor Air airplane holding on a perpendicular taxiway, resulting in their wingtip colliding with the other airplane’s empennage.…NTSB CEN24LA348Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Amarillo, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN24FA346Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Sulphur Springs, INThe pilot’s loss of directional control during takeoff for undetermined reasons.NTSB ERA24LA376Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Raleigh, NCDamage to the landing gear selector switch wire bundle which resulted in an inadvertent retraction of the landing gear during the takeoff roll.NTSB ERA24FA371Accident · 4 fatalClass 3 · FieldFinal reportPiper PA28R · Vergennes, VTThe flight instructor’s failure to maintain control of the airplane, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall. Contributing to the accident was the flight instructor's failure to properly…NTSB CEN24LA344Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 7GCAA · Rifle, COA total loss of engine power for undetermined reasons.NTSB CEN24LA345Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Grand Island, NEThe pilot’s inadequate preflight planning/preparation that resulted in fuel exhaustion during cruise flight, a total loss of engine power, and an impact with terrain during a forced landing.NTSB CEN24LA341Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12-D · Trojan, SDThe partial loss of engine power due to a loose magneto and subsequent impact with terrain.NTSB WPR24FA298Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75L3 · Yacolt, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude in mountainous terrain in moderately high density altitude conditions, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB ERA24LA377Accident · No injuriesClass 4 · LimitedFinal reportMooney M20 · Oxford, CTThe seizure of the right main landing gear extension rod bearing and subsequent buckling of the rod, resulting in a landing gear collapse.NTSB CEN24LA343Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Grand Forks, NDThe student pilot’s failure to maintain helicopter control which resulted in impact with the ground. Contributing to the outcome was the flight instructor’s delayed remedial action.NTSB CEN24FA340Accident · 4 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Anderson, INThe pilot’s inadequate airspeed management during the missed approach which resulted in an inadvertent aerodynamic stall and loss of control at low altitude.NTSB CEN24LA342Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R · Crystal, MNThe failure of the engine mount under normal operating loads due to the fracture of a vertical tube that was weakened by corrosion and fatigue of the internal surfaces.NTSB CEN24LA339Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Borger, TXThe pilot’s inadequate fuel management which led to fuel exhaustion.NTSB ERA24FA365Accident · 2 fatalClass 3 · FieldFinal reportGrumman American Avn. AA-5 · Rockmart, GAA total loss of engine power for undetermined reasons. Also causal was the flight instructor’s failure to maintain adequate airspeed during the forced landing attempt, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic…NTSB ANC24LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Denali, AKFailure to maintain clearance from terrain due to the airplane’s encounter with windshear during takeoff.NTSB CEN24LA337Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · East Troy, WIThe pilot/mechanic’s improper torquing of the fuel hose fitting while replacing the fuel pump, which allowed air to enter the fuel system and resulted in a loss of engine power during initial climb. Contributing to the accident was the pilot/mechanic’s…NTSB CEN24LA333Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac CH601 XL · Odessa, MOOverheating of the engine coolant for reasons that could not be determined, which resulted in a precautionary off-airport landing, during which the airplane sustained substantial damage.NTSB CEN24LA332Accident · 1 fatalClass 3 · LimitedFinal reportApex CROSS-5X · Columbus, NEThe non-certificated pilot’s failure to maintain control of the aircraft after takeoff.NTSB WPR24LA301Accident · No injuriesClass 4 · LimitedFinal reportThompson Ryan L Thompson Craft · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB WPR24LA297Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Saint Johns, AZThe pilot’s improper landing flare that resulted in a hard landing.NTSB WPR24FA291Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8GCBC · Meeteetse, WYThe pilot’s decision to continue the flight over rising terrain at a low altitude in a high-elevation, high-density-altitude environment.NTSB ERA24LA367Accident · Serious injuriesClass 4 · LimitedFinal reportRedfield Thomas C RV-6A · Trinity, VAThe pilots’ improper in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA334Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177B · Shell Knob, MOThe pilot’s failure to maintain aircraft control and airspeed during final approach, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB ANC24LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB WPR24LA300Accident · No injuriesClass 4 · LimitedFinal reportPacific Aerospace 750XL · Mulino, ORThe skydiver’s unintentional parachute deployment and subsequent entanglement with the airplane’s horizontal stabilizer.NTSB WPR24FA290Accident · 1 fatalClass 3 · FieldFinal reportAero Commander 200D · Novato, CAThe pilot’s failure to abort takeoff or compensate for gusty crosswind conditions during takeoff, which resulted in a loss of control and subsequent runway excursion.NTSB DCA24LA295Accident · No injuriesClass 4 · LimitedFinal reportAirbus A330-323 · Atlanta, GADelta Air Lines flight crew’s incorrect evaluation of the clearance between their airplane and the airplane directly ahead of them as they made a 90 degree right turn onto an adjacent taxiway.NTSB CEN24LA336AccidentClass 4 · LimitedFinal reportCessna 182D · Coopersville, MIThe loss of airplane control while landing.NTSB CEN24LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Lawrence, KSThe pilot’s failure to maintain directional control during takeoff.NTSB ANC24LA087Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Lime Village, AKThe pilot’s excessive braking during the landing roll, resulting in a nose over.NTSB ANC24LA086Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150H · Tok, AKThe airplane’s encounter with gusting winds resulting in a loss of altitude with performance insufficient to outclimb terrain.NTSB ANC24FA085Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-18-150 · McGrath, AKThe 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.NTSB WPR24LA303Accident · No injuriesClass 4 · LimitedFinal reportCessna T206H · Big Bend-Gold Bar, WAThe pilot’s improper flare, which resulted in a hard landing.NTSB WPR24LA294Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8 · Bend, ORA failure of the left fuel valve, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA24LA366Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20K · Fairmont, WVThe pilot’s failure to attain the proper touchdown point, and his delay in aborting the landing.NTSB ANC24LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Aleknagik, AKThe pilot’s failure to maintain clearance from terrain while maneuvering at low altitude.