NTSB investigations, 2017
653 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 | 304 |
| 2022 | 315 |
| 2023 | 318 |
| 2024 | 324 |
| 2025 | 244 |
| 2026 | 153 |
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\") = 2017
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") = 2017 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 GAA18CA094Accident · No injuriesData collectionFinal reportPiper PA32 · Spearfish, SDThe pilot’s inadvertent landing in snow adjacent to the snow-covered runway resulting in a collision with runway signs.NTSB CEN18LA064Accident · No injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Paulding, OHThe loss of engine power while the motor-powered glider was maneuvering due to the fuel unporting in its fuel tank, which resulted in fuel starvation and a subsequent forced landing on unsuitable terrain.NTSB ERA18TA059Accident · Minor injuriesFinal reportCessna 172 · Union Mills, NCThe pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing.NTSB CEN18FA061Accident · 5 fatalField investigationFinal reportCessna 340 · Bartow, FLThe pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.NTSB GAA18CA093Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot’s failure to maintain directional control during the landing flare.NTSB CEN18FA060Accident · 1 fatalField investigationFinal reportX-Air XA85 · Oskaloosa, IAThe pilot's low altitude flight into a power line due to his impairment from an acute physiologic event during the flight. Contributing to the pilot's impairment was his use of two sedating medications.NTSB ERA18FA056Accident · 1 fatalField investigationFinal reportBeech G35 · Cross City, FLThe pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in the pilot experiencing spatial disorientation and a subsequent loss of airplane control.NTSB GAA18CA092Accident · Minor injuriesData collectionFinal reportPiper PA28 · Mankato, MNThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent go-around during which the student exceeded the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN18LA071Accident · No injuriesLimited investigationFinal reportPiper PA 12 · Angleton, TXThe passenger's inadvertent activation of the left brake during landing, which resulted in a loss of directional control and a runway excursion.NTSB ERA18LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Ridgeland, SCThe student pilot’s improper control inputs, which resulted in a loss of control on takeoff. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB CEN18LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Versailles, MOThe total loss of engine power due to fuel starvation when the cap fitting came off the inlet tee fitting on the throttle body/fuel metering unit.NTSB ANC18LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA 23-250 · Knoxville, TNThe flight instructor’s failure to comply with published engine-out procedures and recommended airspeeds, which resulted in a lack of directional control, collision with trees, and impact with the ground; the left engine lost total power due to fuel…NTSB CEN18FA054Accident · 2 fatalField investigationFinal reportPiper PA28 · Reeds Spring, MOThe noninstrument-rated pilot's inadequate pre-flight planning and in-flight decision-making, which resulted in flight into known instrument meteorological conditions and the subsequent collision with terrain.NTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…NTSB ERA18LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLThe loose nut connecting the mixture control cable to the mixture control arm, which resulted in the pilot’s inability to control the mixture and the subsequent total loss of engine power.NTSB ERA18LA048Accident · 1 fatalLimited investigationFinal reportCessna 150 · Castalia, NCThe pilot's exceedance of the airplane's critical angle of attack while performing a turning takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's decision to attempt the takeoff, which he believed…NTSB WPR18LA051Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 32-300 · Hinesville, GAA total loss of engine power due to the failure of a connecting rod.NTSB WPR18CA048Accident · Serious injuriesData collectionFinal reportCessna 172P · Valley Springs, CAThe pilot's failure to maintain clearance from trees while maneuvering for landing and his decision to land on a surface with obstructions.NTSB GAA18CA088Accident · No injuriesData collectionFinal reportPiper PA 32R · Kwigillingok, AKThe pilot’s decision to land with the sun in his eyes, which resulted in a short landing.NTSB GAA18CA084Accident · No injuriesData collectionFinal reportCorbeil Shawn Corbeil Shawn SER VI · Rogersburg, ORThe pilot’s improper landing flare and his subsequent failure to see and avoid a tree during a go-around.NTSB WPR18FA046Accident · 2 fatalField investigationFinal reportBeech A36 · San Diego, CAA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN18FA050Accident · 1 fatalField investigationFinal reportSmith Aerostar 601 · Miami, FLThe pilot's loss of control while returning to the airport after takeoff for reasons that could not be determined based on the available information.NTSB GAA18CA082Accident · No injuriesData collectionFinal reportPiper PA28 · Pocasset, OKThe pilot’s improper approach path, which resulted in the airplane landing short of the runway.NTSB CEN18LA051Accident · No injuriesLimited investigationFinal reportCessna 172C · Algona, IAThe No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.NTSB WPR18FA045Accident · 3 fatalField investigationFinal reportBeech C90 · Geneva, FLThe pilot's loss of airplane control due to spatial disorientation during an instrument approach in instrument meteorological conditions, and the flight instructor's delayed remedial action. Contributing to the accident was the flight instructor's impairment…NTSB GAA18CA078Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.NTSB GAA18CA075Accident · Minor injuriesData collectionFinal reportJones Kent C Vans RV-10 · Limon, COThe pilot’s unstabilized approach and failure to go around at night, which resulted in the airplane impacting a power line and a subsequent hard landing.NTSB GAA18CA073Accident · No injuriesData collectionFinal reportBrock Steiner Sport Copter Vortex · Spanish Fork, UTThe pilot’s failure to maintain situational and geographic awareness during the flight, which resulted in him becoming lost and exhausting the gyroplane’s fuel.NTSB ERA18FA046Accident · 5 fatalField investigationFinal reportBeech 58 · St. CroixThe non-multiengine rated pilot's failure to maintain airplane control during a single-engine approach. Contributing to the accident was a total loss of engine power on the left engine due to detonation for reasons that could not be determined based on the…NTSB WPR18LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna 172D · Auburn, WAThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB CEN18FA049Accident · 1 fatalField investigationFinal reportRaytheon B36TC · Chesterfield, MOThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR18LA044Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 34-200T · Glendale, AZThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the fatigue of the left main landing gear assembly.NTSB GAA18CA081Accident · No injuriesData collectionFinal reportPiper PA 32 · Cheboygan, MIThe pilot’s failure to maintain the airplane’s rate of descent in gusting wind conditions resulting in a hard landing and runway excursion.NTSB ERA18LA041Accident · No injuriesLimited investigationFinal reportPiper PA28 · Brewton, ALThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN18LA047Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Rockford, ILThe pilot's inadequate preflight planning and his decision to depart without the required fuel reserve, which resulted in fuel exhaustion during a night approach and subsequent loss of engine power.NTSB WPR18LA043Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36 · Rio Oso, CAAn in-flight fire due to electrical arc corrosion of the fuel line.NTSB CEN18LA048Accident · No injuriesLimited investigationFinal reportPiper PA 31-310 · Jeffersonville, INThe right main landing gear’s failure to fully extend for reasons that could not be determined because postaccident testing revealed no mechanical anomalies that would have precluded normal operation.NTSB WPR18LA042Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Everett, WAThe flight instructor’s inadequate preflight inspection, during which he failed to ensure that water was sufficiently drained from the fuel system, which resulted in total loss of engine power and a subsequent forced landing and impact with objects.NTSB CEN18FA045Accident · 1 fatalField investigationFinal reportPiper Titan Tornado II D · Ravenna, OHThe pilot's failure to maintain adequate airspeed following a loss of engine power during final approach for landing, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB ERA18LA039Accident · 2 fatalLimited investigationFinal reportKevin Leue Sparrow Hawk · Hernando, MSImpact with trees and terrain for reasons that could not be determined based on available evidence.NTSB GAA18CA067Accident · No injuriesData collectionFinal reportTodd Foley Zenith 701 · Mount Airy, NCThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB ANC18LA014Accident · No injuriesLimited investigationFinal reportCessna 172 · Miami, FLThe pilot's decision to continue the landing after a loss of visual cues during a night landing.NTSB GAA18CA076Accident · No injuriesData collectionFinal reportCessna 152 · Fullerton, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA066Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · New Orleans, LAThe pilot’s failure to land the helicopter with both skids on the trailer platform, which resulted in a loss of control.NTSB ERA18LA034Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Westminister, MDThe student pilot's failure to maintain a proper glidepath during the approach due to his distraction by the failure of an avionics panel, which resulted in a runway undershoot.NTSB WPR18LA037Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC41 550FG · Oro Valley, AZThe inadequate cooling time between repeated heavy braking applications, which resulted in the brakes overheating and a subsequent brake fire during the aborted takeoff sequence.NTSB GAA18CA058Accident · No injuriesData collectionFinal reportCessna 182 · Black River Falls, WIThe student pilot’s failure to maintain lateral control of the high-performance airplane during the go-around in crosswind conditions.NTSB CEN18LA042Accident · No injuriesLimited investigationFinal reportMotley Gary W Zenith CH750 Cruzer · Louviers, COThe engine’s excessive cylinder head temperatures and the subsequent seizing of the engine, which resulted from an engine control unit that caused the engine’s fuel-air mixture to be too lean.NTSB GAA18CA059Accident · No injuriesData collectionFinal reportMooney M20 · Tucson, AZThe pilot’s inadequate preflight and in-flight fuel management, which resulted in an intermittent loss of engine power due to fuel starvation.NTSB CEN18LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Midland, TXThe improper installation of the generator by unknown personnel, which resulted in a loss of oil and subsequent engine failure.