NTSB investigations
10,134 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 WPR19LA078Accident · 1 fatalClass 3 · LimitedFinal reportRans S12 · Socorro, NMA loss of control for reasons that could not be determined based on available evidence.NTSB CEN19WA079Accident · 1 fatalForeign investigationCessna 150 · Durango, MexicoNTSB ANC19FA012Accident · 3 fatalClass 2 · FieldFinal reportBeech 200 · Kake, AKA loss of control for reasons that could not be determined based on the available information.NTSB WPR19LA076Accident · Serious injuriesClass 3 · LimitedFinal reportWhittman 8-W Modified · Prospect, ORThe non-certificated pilot’s failure to ensure adequate fuel onboard prior to flight, which resulted in a loss of engine power due to fuel exhaustion.NTSB GAA19CA113Accident · No injuriesData collectionFinal reportCessna 172 · Reno, NVThe student pilot's failure to maintain directional control during a rejected takeoff, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA132Accident · No injuriesData collectionFinal reportPiper PA 18A · McGrath, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the landing gear collapsing.NTSB GAA19CA126Accident · No injuriesData collectionFinal reportCessna 170 · Selah, WAThe pilot's failure to use carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a fence.NTSB GAA19CA114Accident · No injuriesData collectionFinal reportPiper PA22 · Anchorage, AKThe student pilot's overcorrection with rudder during the landing and her subsequent failure to maintain directional control, which resulted in a runway excursion, impact with a snowbank, and a nose-over.NTSB CEN19LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT · Pflugerville, TXThe pilot's fuel mismanagement and his improper use and placement of the fuel selector, contrary to operating procedures, which resulted in a partial loss of engine power due to fuel starvation.NTSB GAA19CA134Accident · No injuriesData collectionFinal reportCessna R172 · Troutdale, ORThe student pilot's failure to maintain the proper pitch attitude during touchdown, which resulted in a bounced landing and subsequent propeller strike.NTSB GAA19CA131Accident · No injuriesData collectionFinal reportPiper PA28 · Williamsburg, VAThe pilot's excessive brake application during the landing roll, which resulted in a runway excursion and collision with a drainage culvert.NTSB GAA19CA109Accident · No injuriesData collectionFinal reportBeech B19 · Los Angeles, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with a fence.NTSB CEN19WA077Accident · 2 fatalForeign investigationRans S12 · Bavispe, MexicoNTSB WPR19FA077Accident · 1 fatalClass 2 · FieldFinal reportRockwell 112 · Mt Hood, ORThe pilot's decision to fly the airplane in close proximity to mountainous terrain in an area of mountain wave activity that exceeded the performance capabilities of the airplane. Contributing to the accident was the pilot's degraded decision making and…NTSB WPR19CA072Accident · No injuriesData collectionFinal reportCessna R172 · Ogden, UTThe student pilot's failure to maintain the runway heading during a touch-and-go landing and the flight instructor's delayed remedial action, which resulted in the airplane departing the left side of the runway, impacting snow, and nosing over.NTSB WPR19LA071Accident · 1 fatalClass 3 · LimitedFinal reportBell 206 · Ashland, ORThe pilot's decision to continue visual flight into deteriorating weather, which resulted in an encounter with instrument meteorological conditions and spatial disorientation leading to a loss of control.NTSB CEN19LA056Accident · 2 fatalLimited investigationFinal reportDouglas DC3C · Kidron, OHThe loss of airplane control after an engine flameout and auto-feather system interruption during the takeoff climb, which resulted in an impact with terrain.NTSB ANC19CA010Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA31 · Chignik Lagoon, AKThe pilot’s selection of an unsuitable runway for landing, which resulted in a loss of control and runway excursion.NTSB GAA19CA115Accident · No injuriesData collectionFinal reportNavion Navion · Patterson, LAThe pilot's failure to maintain clearance from power lines while making an evasive maneuver to avoid birds.NTSB WPR19CA067Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Chino, CAThe pilot's loss of directional control while landing, which resulted in a ground loop.NTSB GAA19CA122Accident · No injuriesData collectionFinal reportCessna 172 · Miami, FLThe student pilot's failure to control the airplane's speed and direction during the approach, which resulted in landing long, a runway excursion, and impact with a windsock.NTSB CEN19CA062Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Iron Mountain, MIThe pilot's distraction and subsequent loss of situational awareness and visual horizon in overcast sky conditions, which led to an unrecognized descent during a low-level maneuver and subsequent impact with snow-covered terrain.NTSB WPR19LA066Accident · 1 fatalClass 2 · LimitedFinal reportPiper PA23 · Ellensburg, WAThe instrument rated pilot’s loss of control due to spatial disorientation.NTSB CEN19LA055Accident · 1 fatalClass 3 · LimitedFinal reportBeech 36 · Fredericksburg, TXThe loss of engine power due to fatigue failure of the crankshaft.NTSB WPR19CA069Accident · No injuriesData collectionFinal reportChampion 7GCBC · Townsend, MTThe pilot's failure to maintain airplane control during a precautionary landing on an uneven, soft surface.NTSB WPR19LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Salt Lake City, UTA partial loss of engine power due to the mechanic’s failure to properly secure the throttle lever locking nut and cotter pin.NTSB CEN19LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Adrian, MIThe airframe and powerplant mechanic's lack of experience in the overhaul of the engine model and the improper torque of the crankshaft gear bolt, which resulted in fatigue failure of the bolt and a total loss of engine power during an approach for landing.NTSB CEN19LA053Accident · 1 fatalLimited investigationFinal reportPiper PA28 · Salem, SDThe incapacitating effects of an acute myocardial infarction (heart attack), which resulted in the pilot's loss of airplane control and impact with terrain.NTSB WPR19TA061Accident · Serious injuriesClass 3Final reportBell 206 · Yuma, AZThe pilot's failure to maintain clearance from power transmission wires while flying at low altitude in nighttime conditions.NTSB CEN19LA065Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Uvalde, TXThe slipping of the sprag clutch due to galling of the sprags and corresponding sprag contact surfaces within the clutch assembly, which rendered the helicopter uncontrollable.NTSB WPR19LA058Accident · 2 fatalClass 2 · LimitedFinal reportBeech A36 · Colusa, CAThe pilot's loss of airplane control due to spatial disorientation shortly after takeoff in instrument meteorological conditions.NTSB ERA19LA080Accident · 2 fatalLimited investigationFinal reportBellanca 1730 · Soddy-Daisy, TNThe pilot's improper decision to attempt an aerobatic maneuver at low altitude, which led to an aerodynamic stall and spin from which the pilot could not recover.NTSB GAA19CA104Accident · No injuriesData collectionFinal reportPiper PA28 · Bowling Green, OHThe student pilot's failure to maintain directional control upon touchdown, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA127Accident · Serious injuriesData collectionFinal reportLuscombe 8 · Casa Grande, AZThe pilot's failure to maintain yaw control and his exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.NTSB GAA19CA116Accident · No injuriesData collectionFinal reportBeech 24 · Edgewood, NMThe pilot's improper landing flare, which resulted in hard, bounced landing, loss of directional control, runway excursion, and impact with a fence and terrain during an attempted go-around.NTSB GAA19CA117Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Longmont, COThe pilot's failure to maintain directional control during landing.NTSB GAA19CA112Accident · No injuriesData collectionFinal reportZlin Savage · Prescott, AZThe pilot's failure to maintain directional control during the landing roll with a tailwind.NTSB GAA19CA110Accident · No injuriesData collectionFinal reportRobinson R44 · Grace, IDThe pilot's failure to maintain clearance from the power lines.NTSB GAA19CA124Accident · Serious injuriesData collectionFinal reportRobinson R44 · Santa Maria Island, FLThe pilot's loss of helicopter control while maneuvering at a low altitude after being struck in the head by a bird.NTSB GAA19CA118Accident · No injuriesData collectionFinal reportCessna 172 · Appleton, MNThe student pilot’s loss of directional control while landing on an ice-covered runway, which resulted in a loss of directional control, and his failure to attain sufficient airspeed during a subsequent aborted landing, which resulted in a nose-over.NTSB CEN19LA051Accident · 1 fatalLimited investigationFinal reportPiper PA 23 · Beaver Island, MIThe pilot's failure to maintain a positive rate of climb after takeoff which resulted in an impact with trees and terrain. Contributing to the accident was the pilot's inability to see a visible horizon due to the dark night lighting conditions and limited…NTSB GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.NTSB GAA19CA111Accident · Minor injuriesData collectionFinal reportCessna 180 · Bend, ORThe pilot's failure to maintain directional control in gusting crosswind conditions.NTSB CEN19LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Horseshoe Bay, TXThe pilot's inadequate preflight and in-flight fuel planning, which resulted in the total loss of engine power due to fuel exhaustion.NTSB CEN19LA050Accident · 1 fatalLimited investigationFinal reportCessna R172K · Chesaning, MIThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB GAA19CA119Accident · No injuriesData collectionFinal reportCessna 172 · Sugar Land, TXThe student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a sign.NTSB WPR19LA050Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Santa Ana, CAA total loss of engine power due to a loose carburetor bowl.NTSB ANC19CA009Accident · No injuriesData collectionFinal reportCessna A185 · Big Lake, AKThe pilot's improper decision to land on a roadway during dark night conditions with inoperable landing and taxi lights, which resulted in an impact with a snow berm.NTSB ERA19LA091Accident · Serious injuriesLimited investigationFinal reportCzech Sport Sportcruiser · Naples, FLCollision with a bird in flight, which resulted in damage to the engine, a fuel leak, and a subsequent total loss of engine power due to fuel exhaustion.NTSB ERA19LA078Accident · 1 fatalLimited investigationFinal reportBRM Aero Bristell S-LSA · Lakeland, FLThe student pilot's exceedance of the airplane's critical angle of attack during the initial climb, resulting in an aerodynamic stall from which the pilot did not recover.