NTSB investigations
10,153 cases where the sequence of events included Collision with terr/obj (non-CFIT).
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA24WA044Accident · 1 fatalClass 4 · ForeignRobinson R66 · Ramallo, ArgentinaNTSB CEN24FA046Accident · 2 fatalClass 3 · FieldFinal reportSocata TBM 700 · Ludington, MIThe pilot’s decision to take off with ice/snow contamination on the airplane’s wings, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA24LA047Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20F · Meridianville, ALThe pilot’s exceedance of the airplane’s critical angle of attack while on final approach to land, which resulted in an aerodynamic stall, a loss of airplane control, and impact with terrain.NTSB WPR24LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Woodland, WAThe flight instructor’s inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA24FA038Accident · 2 fatalClass 3 · FieldFinal reportXtremeair XA42 · Union City, TNThe pilot receiving instruction’s loss of airplane control while performing aerobatics, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the flight instructor’s inadequate supervision.NTSB WPR24FA035Accident · 2 fatalClass 3 · FieldFinal reportCessna 172G · Provo, UTThe pilot's exceedance of the airplane's critical angle of attack during a chandelle maneuver, which resulted in an aerodynamic stall and descent into trees and terrain. Contributing to the accident was the pilot’s decision to maneuver into a canyon and…NTSB ERA24FA036Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Micanopy, FLThe non-instrument-rated pilot’s improper inflight decision making and his flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident were the pilot’s…NTSB CEN24LA036Accident · No injuriesClass 3 · LimitedFinal reportTextron 172S · Erie, COA partial loss of engine power while maneuvering at a low altitude due to a stuck exhaust valve.NTSB CEN24LA033Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 500-B · Jackson, MIA loss of engine power to both engines as a result of the pilot’s improper fuel management. Contributing was the inoperative fuel quantity sending unit.NTSB GAA24WA024Accident · 4 fatalClass 3 · ForeignRobinson R44 · Cirque de Salazie, RéunionNTSB ERA24LA030Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Pembroke Pines, FLThe pilot’s loss of airplane control and descent into terrain due to spatial disorientation during a solo night cross country flight. Contributing to the accident was the pilot’s self-reported fatigue.NTSB ERA24FA026Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Marion, OHA descent and impact with terrain for undetermined reasons.NTSB ERA24LA031Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ocklawaha, FLThe pilot’s failure to attain a proper touchdown point which resulted in a runway overrun and subsequent impact with a fence.NTSB WPR24LA025Accident · Serious injuriesClass 4 · LimitedFinal reportGulfstream Aerospace Commander 690C · Reno, NVThe pilot applicant’s excessive nose down pitch, and the check pilot’s delayed remedial action, which resulted in an impact with terrain.NTSB ERA24LA022Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20E · Pembroke Pines, FLThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB CEN24FA021Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Vidalia, LAThe pilot’s failure to maintain clearance from power lines during an aerial application flight. Contributing to the accident was the pilot’s cell phone use and the position of the sun, which reduced the pilot’s ability to perceive the location of the power…NTSB CEN24LA020Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA 46-350P · Pierre, SDThe total loss of engine power due to fuel starvation as a result of the pilot’s improper configuration of the automatic fuel transfer system. Contributing to the accident was the pilot’s failure to adequately monitor the header tank’s fuel quantity.NTSB ERA24LA086Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Morganton, NCThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and an impact with the runway’s precision approach path indicator (PAPI) lights.NTSB ERA24LA018Accident · No injuriesClass 3 · LimitedFinal reportRoth Frank Ronald Avid Aircraft · Knoxville, TNA total loss of engine power due to a seized piston in the power take-off cylinder.NTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaNTSB ERA24LA016Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · Richmond, VAThe loss of engine power due to a restriction of fuel flow as a result of a fractured float bracket in the carburetor.NTSB WPR24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · The Dalles, ORThe pilot’s encounter with severe turbulence at night which resulted in an extended downwind and collision with wires during the base turn.NTSB ERA24LA011Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P2010 · Ocala, FLA total loss of engine power for reasons that could not be determined. Contributing to the accident was the flight instructor’s failure to maintain adequate airspeed and exceedance of the airplane’s critical angle of attack during the forced landing, which…NTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeNTSB CEN24LA011Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Red Oak, IAThe fatigue failure of the exhaust valve due to excessive combustion deposits, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s failure to ensure that the required scheduled maintenance was completed.NTSB ERA24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportMonocoupe 90AL-115 · Myakka City, FLThe pilot’s failure to maintain adequate clearance from a fence during takeoff.NTSB GAA24WA124Accident · 4 fatalClass 5 · ForeignRobin DR400-180 · Propriano, FranceNTSB CEN24FA010Accident · 2 fatalClass 3 · FieldFinal reportCessna 414 · Patterson, LAThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.NTSB ERA24LA006Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Jonesboro, GABoth pilots’ inadequate preflight inspection and inadequate fuel monitoring during the flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA24WA015Accident · 2 fatalClass 5 · ForeignCessna 172N · Merriton, AustraliaNTSB ERA24FA003Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · Croydon, NHThe pilot’s loss of control during the initial climb in dark night conditions due to spatial disorientation, which resulted in a steep banking descent into trees and terrain. Contributing to the accident was the pilot’s lack of recent night flight experience,…NTSB GAA24WA016Accident · No injuriesClass 5 · ForeignChristen Industries A1 · Hida Air Park, JapanNTSB ERA24LA023Accident · No injuriesClass 3 · LimitedFinal reportChampion 7FC · Hawkinsville, GAThe failure of the carburetor fuel line, which resulted in fuel starvation.NTSB WPR24LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 340A · Hayward, CAThe pilot’s sudden incapacitation from effects of a previously undiagnosed underlying heart disease, which resulted in his loss of control of the airplane and subsequent impact with terrain.NTSB CEN24LA005Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Cahokia Heights, ILThe student pilot’s failure to maintain helicopter control which resulted in impact with the ground.NTSB ERA24FA001Accident · 2 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Placid, NYA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s inadequate preflight weight and balance planning and his aggressive low altitude maneuvering, which resulted in an aerodynamic stall and loss of control.NTSB ERA23LA385Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206 · Port Clinton, OHThe pilot’s failure to detect and avoid unmarked powerline(s) while attempting to take off from a river.NTSB ERA23LA383Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Towanda, PAA total loss of engine power during initial climb for undetermined reasons.NTSB ERA23FA384Accident · 1 fatalClass 3 · FieldFinal reportCessna 150K · Gilford, NHThe pilot’s loss of control during visual flight rules flight in night instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot’s motivation to depart on the flight despite being made aware that conditions…NTSB ERA23LA387Accident · No injuriesClass 4 · LimitedFinal reportJohn W Moll Vans RV-7 · Liberty, SCThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and substantial damage to the left wing and left horizontal stabilizer.NTSB ERA23FA382Accident · 1 fatalClass 3 · FieldFinal reportSmith William S Smith Cozy Mark IV · Cullman, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot/owner’s improper installation of engine…NTSB CEN23LA423Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Broken Bow, OKThe pilot’s failure to maintain the runway centerline during landing and subsequent failure to maintain clearance from the airport grounds worker during the landing roll. Contributing to the accident was the absence of a NOTAM for mowing operations at the…NTSB CEN23LA424Accident · Serious injuriesClass 3 · LimitedFinal reportPowrachute Pegasus · Caddo Mills, TXThe pilot’s inadequate rolling preflight, which resulted in a loss of directional control in flight and subsequent collision with an object during landing.NTSB WPR23LA357Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Redding, CAThe student pilot’s loss of airplane control during takeoff, which resulted in a bounced landing and impact with the airport’s windsock.NTSB CEN23LA422Accident · Minor injuriesClass 4 · LimitedFinal reportQuicksilver Sport II · Welsh, LAThe pilot’s failure to maintain sufficient altitude from obstacles during the simulated landing approach which led to a collision with a fence and a building.NTSB ANC23LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 182K · Trimble River Valley, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in the left main landing gear (MLG) tire impacting a rock, resulting in the separation of the MLG wheel, and the subsequent loss of directional control.NTSB CEN23LA419Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · El Dorado, ARA loss of engine power for undetermined reasons, which resulted in a forced landing and impact with terrain.NTSB WPR23LA349Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Compton, CAThe total loss of engine power on takeoff due to water-contaminated fuel. Contributing to the accident was the inadequately maintained fuel system, which resulted in water entering the fuel tanks through the filler caps.NTSB GAA23WA269Accident · No injuriesClass 5 · ForeignBell 204B · Aratula, AustraliaNTSB ERA23LA381Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75 · Erwinna, PAThe pilot’s failure to maintain control of the airplane while taking off in a crosswind.