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 WPR24FA184Accident · 1 fatalClass 3 · FieldFinal reportBeech A45 · Deer Harbor, WAThe pilot’s decision to perform an aerobatic maneuver at low level, and his misjudged entry altitude for the maneuver, which resulted in impact with water.NTSB WPR24FA182Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Auburn, WAThe pilot’s improper installation of the control stick pushrod assemblies, which resulted in separation of the left pushrod and a total loss of roll control during flight. Contributing to the accident was the failure to detect the installation error during…NTSB CEN24LA216Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Perryton, TXThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level turn, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB WPR24LA180Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Butte, MTThe pilot’s failure to maintain control of the airplane during the takeoff with a gusty left quartering crosswind.NTSB WPR24LA175Accident · Minor injuriesClass 4 · LimitedFinal reportDennis T Kirby/Michael B Kirby Murphy Rebel · Edgewood, NMThe pilot’s improper installation of the aileron and flap control systems, which resulted in a loss of directional control during the takeoff roll and subsequent runway excursion.NTSB GAA24WA214Accident · 2 fatalClass 5 · ForeignBeech 55 · Santa Catarina, BrazilNTSB ERA24LA241Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Terryville, CTA total loss of engine power for undetermined reasons.NTSB ERA24LA291Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Benton, NHAn encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in collision with trees.NTSB ERA24LA243Accident · Minor injuriesClass 4 · LimitedFinal reportEide Turner T-40A · Middleburg, FLThe pilot’s loss of control during climb out, which resulted in a collision with a tree.NTSB ERA24LA242Accident · Serious injuriesClass 4 · LimitedFinal reportHughes 269A · Danbury, NHThe pilot’s inadequate compensation for the prevailing wind conditions, which resulted in a loss of control during landing.NTSB ERA24LA239Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · San Juan, PRA partial loss of engine power due to the failure of the No. 2 cylinder rocker shaft bosses from fatigue cracking.NTSB ERA24LA238Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Geneseo, NYThe pilot’s failure to maintain directional control during the takeoff roll resulting in a runway excursion, and subsequent nose over.NTSB ERA24LA233Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32RT · Palmetto, FLThe pilot’s improper decision to re-attempt a takeoff with little runway remaining, after rejecting a takeoff in gusting wind conditions, which resulted in a runway overrun at a higher speed and collision with terrain.NTSB CEN24LA201Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Oscoda, MIThe pilot’s failure to maintain directional control during landing rollout with a gusting crosswind that resulted in the airplane nosing over and impacting on the runway.NTSB WPR24LA164Accident · No injuriesClass 4 · LimitedFinal reportBoeing-Stearman PT-17 · Heber City, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA24LA229Accident · Serious injuriesClass 3 · LimitedFinal reportGreat Lakes 2T-1(Menasco Special) · Salisbury, MDThe pilot’s exceedance of the airplane’s critical angle of attack, resulting in an aerodynamic stall and loss of control.NTSB ERA24LA227Accident · 1 fatalClass 3 · LimitedFinal reportBrallier Scott Glasair I · Gulf of Mexico, FLThe non-instrument-rated pilot’s loss of airplane control due to spatial disorientation while flying over water in dark night conditions. Contributing to the accident was the pilot’s decision to conduct the overwater flight in conditions conducive to the…NTSB CEN24LA198Accident · No injuriesClass 4 · LimitedFinal reportBrant T Phillips Super Cub EXP · Franktown, COThe pilot’s failure to maintain aircraft control during final approach and attempted go-around after encountering a sudden windshear.NTSB ERA24LA228Accident · Serious injuriesClass 3 · LimitedFinal reportSchleicher ASH 31 MI · Winter Haven, FLThe pilot’s failure to ensure that a suitable landing area was available in case the restart of the motor glider’s engine was unsuccessful. Contributing, was insufficient battery charge to extend the motor glider’s pylon assembly.NTSB ERA24LA223Accident · No injuriesClass 3 · LimitedFinal reportBeechcraft TC-12B · Lehigh Acres, FLThe asymmetric reverse thrust during the landing roll for reasons that could not be determined, resulting in the flightcrew’s inability to maintain directional control and a subsequent runway excursion.NTSB ERA24FA221Accident · 1 fatalClass 3 · FieldFinal reportRadley Vincent Quicksilver Sport 2S · Cleveland, GAThe pilot’s failure to maintain control of the airplane during the takeoff and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and spin at low altitude. Contributing to the accident was the pilot’s lack of…NTSB ERA24LA222Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 177 · Selma, ALInsufficient lubrication of the engine’s internal components, which resulted in a total loss of engine power.NTSB CEN24LA193Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502 · Covert, KSThe improper maintenance of the fuel control unit, which resulted in air leakage and a loss of control of fuel flow to the engine.NTSB WPR24LA191Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Prescott, AZThe student pilot’s failure to maintain directional control during landing following an aborted takeoff which resulted in a runway excursion and impact with a ditch.NTSB ERA24LA224Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Lagrangeville, NYThe pilot’s failure to maintain control of the airplane during the landing and subsequent go-around attempt. Also causal was the flight instructor’s delayed remedial action.NTSB WPR24LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Lakeport, CAThe pilot’s inadequate use of carburetor heat, which resulted in a total loss of engine power shortly after takeoff due to fuel starvation as a result of carburetor ice.NTSB CEN24FA188Accident · 1 fatalClass 3 · FieldFinal reportCessna 150L · Godley, TXThe student pilot’s failure to maintain airplane control while practicing a power-on stall, which resulted in an inadvertent spin at an altitude from which he was unable to recover.NTSB CEN24LA189Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Hot Springs, ARThe student pilot’s selection of an improper fuel tank selector position, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the instructor’s inadequate oversight.NTSB CEN24FA179Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Marianna, ARThe pilot’s exceedance of the airplane’s design limitations, which resulted in an in-flight breakup.NTSB CEN24LA194Accident · Serious injuriesClass 4 · LimitedFinal reportLanni Charles T Skyranger II · Breaux Bridge, LAThe pilot’s decision to depart with the airplane over maximum gross weight, which reduced the climb performance and resulted in a collision with a tree.NTSB CEN24LA181Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Chesaning, MIThe pilot’s failure to maintain control while landing on a wet turf runway, which resulted in a runway excursion and impact with trees. Contributing to the accident was the pilot’s failure to ensure the passenger’s proper use of seatbelts before the landing.NTSB WPR24LA148Accident · No injuriesClass 3 · LimitedFinal reportKjelsrud Gary Kitfox · Powell, WYThe pilot’s adjustment of the carburetor to an incorrect setting, which resulted in partial loss of engine power during takeoff.NTSB WPR24LA145Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Big Bear, CAThe pilot’s failure to maintain directional control during takeoff with a gusty crosswind.NTSB ERA24LA211Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Apopka, FLA partial loss of engine power due to sticking exhaust valves. Contributing to the accident was maintenance personnel’s failure to use available engine data while troubleshooting a known engine issue and maintenance personnel’s failure to comply with…NTSB CEN24LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Midland, TXThe pilot’s failure to maintain airplane control during a go-around in a gusting crosswind, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot’s lack of system knowledge regarding the operation of the…NTSB ERA24LA210Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Titusville, FLThe pilot’s failure to maintain directional control while landing in variable wind conditions, which resulted in runway excursion and collision with an approach light.NTSB GAA24WA194Accident · No injuriesClass 3 · ForeignBell 206 · Bages, FranceNTSB GAA24WA162Accident · 3 fatalClass 5 · ForeignCessna 406 · Windhoek City, NamibiaNTSB ERA24FA206Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · Augusta, GAThe pilot’s excessive turn rate and bank angle while at low airspeed and altitude, resulting in an accelerated aerodynamic stall, loss of airplane control, and collision with terrain.NTSB ERA24LA213Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Apex, NCThe loss of directional control during the landing roll for reasons that could not be determined, due to impact damage sustained to the brake system.NTSB ERA24LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Westminster, MDThe pilot’s failure to attain a proper touchdown point during a simulated loss of engine power approach, which resulted in a hard landing short of the runway. Also causal was the flight instructor’s delayed remedial action during the approach and subsequent…NTSB CEN24LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 172H · Belle Chasse, LAThe inadequate landing flare by the flight instructor that resulted in a loss of directional control and impact with terrain.NTSB CEN24LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · England, ARThe pilot’s failure to maintain clearance from tower guy wires while maneuvering during a low-level aerial application flight.NTSB WPR24LA143Accident · Minor injuriesClass 4 · LimitedFinal reportThatcher CX4 · Rowley, UTThe pilot’s failure to maintain directional control during the takeoff roll.NTSB ERA24LA198Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Palatka, FLThe failure of the nose oil seal to remain secure in the engine crankcase, which resulted in a loss of engine oil and partial loss of engine power.NTSB ERA24LA195Accident · No injuriesClass 4 · LimitedFinal reportReddick Jonathan L Zodiac 601XLB · Dunbar, PAA total loss of engine power as a result of an improperly fabricated fuel-air mixture cable bracket. Contributing was the pilot’s decision to fly the airplane with a known mechanical engine issue, and the presence of another airplane that was back taxiing on…NTSB ERA24LA196Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Endicott, NYThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a runway excursion, and subsequent collision with trees.NTSB ERA24LA190Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B24R · Lumberton Township, NJThe pilot/owner’s failure to ensure adequate maintenance of the airplane, which resulted in a partial loss of engine power during takeoff.NTSB ERA24LA185Accident · 1 fatalClass 3 · LimitedFinal reportBailey-Moyes Dragonfly · Groveland, FLThe pilot’s improper installation and inspection of the right lower wing strut attachment bolt, which resulted in the inflight failure of the right wing.NTSB ERA24LA182Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150L · Sussex, NJThe student pilot’s failure to maintain airplane control during a go-around attempt in a gusting left crosswind, resulting in an aerodynamic stall and collision with terrain.