NTSB investigations, 2018
669 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 759 |
|---|---|
| 2009 | 598 |
| 2010 | 655 |
| 2011 | 783 |
| 2012 | 766 |
| 2013 | 625 |
| 2014 | 671 |
| 2015 | 674 |
| 2016 | 697 |
| 2017 | 653 |
| 2018 | 669 |
| 2019 | 620 |
| 2020 | 324 |
| 2021 | 303 |
| 2022 | 315 |
| 2023 | 318 |
| 2024 | 324 |
| 2025 | 245 |
| 2026 | 154 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2018
AND 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 year(c."eventDate") = 2018 AND 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 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.NTSB WPR19LA049Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft L 2M · Walla Walla, WAThe pilot's improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN19LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Abilene, TXThe pilot's failure to see and avoid a cell tower wire during a pipeline patrol flight. Contributing to the accident was the pilot's distraction due to writing down observations about the pipeline while flying.NTSB GAA19CA123Accident · Minor injuriesData collectionFinal reportCessna 172 · Center, TXThe pilot's exceedance of the airplane's critical angle of attack during landing in gusting crosswind conditions, which resulted in an aerodynamic stall.NTSB ERA19LA072Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA46 · Mayport, FLAn in-flight loss of control following an encounter with supercooled large droplet icing conditions, which ultimately resulted in an uncontrolled descent and subsequent inflight breakup. Also causal was the pilot’s failure to maintain an appropriate airspeed…NTSB ERA19FA071Accident · 4 fatalField investigationFinal reportCessna 560 · Atlanta, GAThe pilot's loss of airplane control due to spatial disorientation during initial climb in instrument meteorological conditions.NTSB GAA19CA102Accident · No injuriesData collectionFinal reportBeech 36 · Sedona, AZThe pilot's failure to maintain the proper airspeed during landing, which resulted in the airplane landing too fast and too far down the runway to safely stop it.NTSB ERA19LA074Accident · Minor injuriesClass 3 · LimitedFinal reportDiamond DA20 · McCormick, SCA partial loss of engine power due to debris obstructing the metering plug orifice in the throttle and metering unit.NTSB WPR19FA042Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-24-250 · Aberdeen, IDThe pilot's diverted attention during the takeoff climb due to a loss of engine power, which resulted in the airplane’s exceedance of the critical angle of attack and subsequent stall/spin.NTSB GAA19CA098Accident · No injuriesData collectionFinal reportCessna 170 · Riggins, IDThe pilot's improper preflight performance planning and his subsequent failure to attain sufficient speed for the airplane to climb with a tailwind.NTSB CEN19LA047Accident · No injuriesLimited investigationFinal reportRans S12 · McClure, OHThe cold seizure of the cylinder/piston due to the pilot’s failure to adequately warm the engine before takeoff, which resulted in a loss of engine power during a departure climb.NTSB GAA19CA101Accident · No injuriesData collectionFinal reportClifford E Massey AR-1 · Anahuac, TXThe pilot's improper landing flare in gusting crosswind conditions.NTSB ERA19FA066Accident · 1 fatalField investigationFinal reportEipper Quicksilver · Fredericksburg, VAThe pilot's exceedance of the airplane's critical angle of attack, which led to an aerodynamic stall while turning in the traffic pattern at low altitude.NTSB WPR19LA041Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Hawker Hntr FMK 58 · Honolulu, HIA total loss of engine power for undetermined reasons.NTSB ERA19LA065Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Sport Piper Sport · Punta Gorda, FLA total loss of engine power due to an interruption of fuel flow.NTSB CEN19FA044Accident · 1 fatalField investigationFinal reportPiper PA24 · Valparaiso, INThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.NTSB GAA19CA096Accident · No injuriesData collectionFinal reportBeech 36 · Hartford, WIThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and impact with terrain during landing in icing conditions.NTSB GAA19CA095Accident · No injuriesData collectionFinal reportPiper PA28 · Chino, CAThe flight instructor's failure to maintain directional control during landing.NTSB GAA19CA091Accident · No injuriesData collectionFinal reportZlin Z143 · Chester, CTThe pilot's loss of airplane control during the engine start.NTSB ERA19LA062Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Paramus, NJMaintenance personnel's improper assembly of the engine during overhaul, which resulted in lubrication restriction due to a bearing shift and the subsequent engine failure.NTSB GAA19CA090Accident · Minor injuriesData collectionFinal reportZenair CH 750 Cruzer · Hesperia, CAThe pilot's improper landing flare, which resulted in hard, bounced landing, runway excursion, and impact with a hangar.NTSB WPR19LA039Accident · No injuriesClass 3 · LimitedFinal reportBeech 36 · Los Banos, CAA partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA088Accident · No injuriesData collectionFinal reportPiper PA28 · Cornelia, GAThe flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.NTSB GAA19CA087Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, NCThe student pilot's improper landing flare, which resulted in a hard, bounced landing and nose landing gear collapse.NTSB CEN19WA040Accident · 4 fatalForeign investigationCessna U206 · Culiacan, Sinaloa, MexicoNTSB WPR19LA035Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172P · Santa RitaA total loss of engine power for undetermined reasons.NTSB ERA19FA060Accident · 2 fatalClass 2 · FieldFinal reportCessna 335 · Fort Lauderdale, FLThe pilot's improper decision to fly the unairworthy airplane and his failure to feather the left propeller following a partial loss of power from the left engine after takeoff. Also causal was the partial loss of power to the left engine due to detonation.NTSB GAA19CA089Accident · No injuriesData collectionFinal reportPiper J4 · Forest, VAThe student pilot's improper landing flare and subsequent failure to maintain directional control during landing.NTSB CEN19FA036Accident · 3 fatalClass 3 · FieldFinal reportCessna 525 · Memphis, INThe pilot’s inability to regain airplane control after a left roll that began for reasons that could not be determined based on the available evidence.NTSB GAA19CA080Accident · No injuriesData collectionFinal reportPiper PA 12 · Burlington, WAThe pilot's failure to maintain directional control while landing in crosswind conditions.NTSB ERA19LA057Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Kennesaw, GAThe total loss of engine power due to the interruption of oil circulation for reasons that could not be determined based on the available evidence.NTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…NTSB GAA19CA099Accident · Minor injuriesData collectionFinal reportCirrus SR20 · Jasper, GAThe student pilot's exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall, and the flight instructor's delayed remedial action.NTSB GAA19CA084Accident · Serious injuriesData collectionFinal reportPiper PA28 · Casa Grande, AZThe student pilot's failure to maintain a proper glidepath during the approach, which resulted in impact with a fence and terrain.NTSB GAA19CA083Accident · No injuriesData collectionFinal reportSmith AEROSTAR601 · Rock Hill, SCThe pilot's improper decision to fly with an air cast boot on his foot, which led him to rely on the passenger to apply brakes and rudder, which was performed improperly and led to a loss of directional control.NTSB CEN19FA032Accident · 1 fatalField investigationFinal reportMooney M20C · Santa Fe, NMCollision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's poor preflight planning and poor decision to depart on the accident flight.NTSB ANC19LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Whittier, AKA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB GAA19CA072Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Benson, AZThe pilot's overcorrection during the landing, which resulted in a loss of directional control.NTSB GAA19CA076Accident · No injuriesData collectionFinal reportCessna 172 · Ogden, UTThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA19CA074Accident · No injuriesData collectionFinal reportCirrus SR22 · Sand Creek, WIThe mechanic's failure to properly secure the air reference line, which resulted in a loss of engine power.NTSB WPR19TA034Accident · Minor injuriesClass 3Final reportCessna 172 · Colorado Springs, COThe pilot's decision to perform a touch-and-go landing at a high-density altitude airport, with a tailwind, and on an upsloping runway, which resulted in decreased airplane performance and the airplane’s inability to become airborne within the available…