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 ERA23FA138Accident · 2 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 · West Palm Beach, FLThe pilots’ exceedance of the airplane’s critical angle of attack following a go-around/low pass over the runway, which resulted in a loss of control and impact with terrain.NTSB ERA23FA136Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-22-150 · Blue Ridge, GAA loss of engine power due to fuel starvation due to the improper positioning of the fuel selector.NTSB WPR23LA120Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Vernalis, CAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight.NTSB GAA23WA090Accident · 2 fatalClass 5 · ForeignAir Tractor AT402 · Fazenda Juína, Juína - MT, BrazilNTSB WPR23LA118Accident · No injuriesClass 4 · LimitedFinal reportBell UH-1B · Orland, CAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a loss of engine power.NTSB ERA23LA132Accident · Serious injuriesClass 3 · LimitedFinal reportStilp Tanner E Savannah S · Trenton, SCThe loss of control during the base turn to final due to the impingement of the Y-stick control by a notepad.NTSB ERA23LA133Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-12 · Ebeemee Township, MEA partial power loss of engine power during initial climb for undetermined reasons.NTSB ERA23FA130Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Duluth, MNA rapid descent and subsequent collision with terrain for reasons that could not be determined based on the available evidence.NTSB CEN23LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Martinsville, INThe pilot’s inadequate weather evaluation and failure to abort the takeoff that resulted in an impact with terrain.NTSB CEN23FA113Accident · 5 fatalClass 3 · FieldFinal reportBeech B200 · Little Rock, ARThe loss of control during initial climb for undetermined reasons. Contributing to the accident were the sudden wind shifts during the initial climb.NTSB WPR23LA111Accident · Serious injuriesClass 4 · LimitedFinal reportGlasair Sportsman · Cal-Nev-Ari, NVThe pilot’s improper decision to takeoff with known damage to the wing and his failure to maintain directional control during takeoff on rough terrain.NTSB CEN23LA118Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8E · Houston, TXThe pilot’s failure to attain/maintain lateral airplane control during landing, which resulted in an impact with the runway surface.NTSB CEN23LA111Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Moline, ILThe student pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB WPR23LA112Accident · 1 fatalClass 3 · LimitedFinal reportStar Lite SL1 · Corning, CAThe student pilot’s loss of airplane control during an intentional aerobatic maneuver, which resulted in an inflight separation of the left wing and subsequent impact with the terrain.NTSB WPR23LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Fullerton, CAThe student pilot's failure to maintain control of the airplane during the landing roll and the flight instructor’s delayed remedial action, which resulted in an impact with an obstacle.NTSB ANC23LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Chugiak, AKThe pilot’s failure to maintain directional control during takeoff in flat light conditions which resulted in a loss of control and impact with a snow berm.NTSB GAA23WA072Accident · 2 fatalClass 4 · ForeignRobinson R44 · Vargem Alta, BrazilNTSB ERA23LA124Accident · Serious injuriesClass 3 · LimitedFinal reportCanton Paul A RV-6 · Milton, FLThe incorrect installation of the fuel pickups, which resulted in a total loss of engine power due to fuel starvation. Contributing was the lack of documentation of the airplane’s unusable fuel.NTSB CEN23LA133Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Hilbert, WIThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23LA103Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 425 · Bismarck, NDA loss of braking due to inadequate servicing of brake fluid by the pilot/mechanic, which resulted in a loss of airplane control on the ground.NTSB WPR23LA103Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Porterville, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.NTSB CEN23LA109Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Montevideo, MNThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA23LA123Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA46 · Port Orange, FLThe pilot’s failure to maintain aircraft control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and collision with trees.NTSB CEN23LA097Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Cleveland, TXThe pilot’s decision to attempt the night flight under visual flight rules when instrument meteorological conditions prevailed resulting in the airplane striking trees while on final approach. Contributing to the accident were the unserviceable runway lights…NTSB ERA23LA120Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20C · Calhoun, GAA partial loss of engine power during the initial climb due to an improperly installed spark plug.NTSB ERA23LA119Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 · Miami, FLThe pilot’s mismanagement of fuel supply, which resulted in fuel starvation.NTSB CEN23LA096Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-235 · Chickala, ARThe pilot’s decision to land on the snow-covered runway and his failure to attain/maintain aircraft control during landing rollout.NTSB CEN23LA093Accident · 1 fatalClass 4 · LimitedFinal reportCirrus Design SR20 · Indianapolis, INThe pilot’s intentional flight into terrain as an act of suicide.NTSB CEN23LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Eden Prairie, MNThe student pilot exceeded the airplane's critical angle of attack, resulting in an aerodynamic stall and ground impact.NTSB GAA23WA065Accident · Minor injuriesClass 4 · ForeignPiper PA32R · Isla Martin Garcia, ArgentinaNTSB CEN23LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Las Animas, COThe student pilot’s loss of control during approach for landing and the flight instructor’s inadequate supervision of the approach and delay in ensuring a go-around was performed at the onset of a stall warning.NTSB CEN23LA081Accident · Serious injuriesClass 3 · LimitedFinal reportPitts Model 12 · Conroe, TXThe failure of the engine-driven fuel pump, which resulted in a total loss of engine power. Contributing to the failure of the fuel pump was an unknown non-ferrous metallic debris that was noted throughout the airplane’s fuel system.NTSB ERA23FA109Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Dawsonville, GAThe pilot’s decision to initiate a visual flight rules flight into night instrument meteorological conditions, resulting in a loss of control in-flight due to spatial disorientation. Contributing to the accident was the pilot’s lack of qualifications and…NTSB ANC23LA018Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-180 · Glennallen, AKThe pilot’s failure to maintain airspeed during a drag maneuver, which resulted in an overrun and subsequent impact with terrain.NTSB GAA23WA056Accident · 1 fatalClass 5 · ForeignAero Eli Servizi Yoyo · Lesna Jania, PolandNTSB WPR23LA086Accident · Serious injuriesClass 3 · LimitedFinal reportQuad City Challenger · Kent, WAThe pilot’s inflight loss of airplane control. Contributing to the accident was the pilot’s decision to fly the airplane without receiving training in its operation and flight characteristics.NTSB ERA23FA103Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Suffolk, VAThe pilot’s decision to fly the airplane without confirming it had been released from maintenance, which resulted in a partial loss of engine power due to loose magnetos. Contributing to the outcome was the pilot’s failure to maintain adequate airspeed and…NTSB ERA23LA105Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Paris, KYThe pilot’s loss of control after encountering changing wind conditions during the initial climb, which resulted in descent and collision with terrain.NTSB WPR23FA083Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-34-220T · New Harmony, UTThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation.NTSB ERA23LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Opa-locka, FLThe flight instructor’s decision to taxi behind a large multi-engine airplane, which resulted in an encounter with propeller blast and a loss of airplane control on the ground.NTSB WPR23FA080Accident · 1 fatalClass 3 · FieldFinal reportEmbraer Executive EMB-505 · Provo, UTThe pilot’s failure to deice the airplane before takeoff in weather conditions conducive to ice accumulation, which resulted in an ice-contaminated wing and subsequent stall during takeoff.NTSB ERA23LA097Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Athens, GAThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a loss of engine power.NTSB GAA23WA084Accident · 1 fatalClass 5 · ForeignSocata TB21 · Saint-Pons, FranceNTSB CEN23LA070Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BF · Navasota, TXThe student pilot failed to maintain directional control during landing.NTSB CEN23LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · South St. Paul, MNThe student pilot’s failure to maintain directional control during the take-off roll with a snow and ice covered runway.NTSB WPR23LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35B · Livermore, CAThe pilot’s inadvertent use of the mixture control instead of the throttle, which resulted in fuel starvation and the subsequent loss of engine power.NTSB GAA23WA051Accident · 2 fatalClass 5 · ForeignCessna 210N · Bulman, AustraliaNTSB CEN23LA067Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172F · Auburn Hills, MIThe catastrophic engine failure due to lack of oil lubrication, which resulted from the pilot’s failure to follow the airplane and engine manufacturers’ guidance for cold weather operation.NTSB WPR23LA074Accident · Minor injuriesClass 4 · LimitedFinal reportRoyse Ralph L Glasair · Cottonwood, CAThe pilot’s fuel mismanagement which resulted in fuel starvation and a total loss of engine power.NTSB GAA23WA042Accident · 1 fatalClass 5 · ForeignPiper PA 46-350P · Happy Valley-Goose Bay, Canada