NTSB investigations, 2016
697 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 | 306 |
| 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\") = 2016
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") = 2016 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 CEN17FA063Accident · 3 fatalField investigationFinal reportPiper PA28R · McKinney, TXThe other pilot's use of an alternate traffic pattern entry procedure, which resulted in his inability to see and avoid the airplane, which was flying the preferred traffic pattern, and the subsequent midair collision.NTSB WPR17FA044Accident · 4 fatalField investigationFinal reportCessna 182 · Dabob, WAThe non-instrument-rated pilot's decision to continue a night visual flight rules into instrument flight rules conditions, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot's failure to obtain…NTSB ERA17LA077Accident · No injuriesLimited investigationFinal reportBeech 76 · Dunnellon, FLAn inadequate 100-hour maintenance inspection that failed to detect and correct loose nuts on a single-drive dual magneto, which led to the subsequent separation of the magneto from the engine during initial climb and the total loss of engine power.NTSB CEN17FA072Accident · 6 fatalField investigationFinal reportCessna 525 · Cleveland, OHControlled flight into terrain due to pilot spatial disorientation. Contributing to the accident was pilot fatigue, mode confusion related to the status of the autopilot, and negative learning transfer due to flight guidance panel and attitude indicator…NTSB WPR17LA050Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Kingman, AZThe loss of engine oil pressure during cruise flight, which resulted in partial loss of engine power and necessitated a forced landing. The loss of oil pressure was the result of a failed engine piston, likely initiated by foreign object damage, which…NTSB WPR17LA043Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Mt. Baldy, CAThe pilot's failure to maintain main rotor speed during a low orbiting approach over a confined mountainous area. Contributing to the accident was the pilot's decision to attempt to land in an area that did not allow for a safe exit path under conditions near…NTSB GAA17CA105Accident · No injuriesData collectionFinal reportPiper PA 46 · Nashville, TNThe pilot’s loss of directional control during the aborted landing in gusting crosswind conditions, which resulted in a runway excursion.NTSB CEN17LA090Accident · No injuriesLimited investigationFinal reportCessna 172B · Prairie Du Sac, WIThe pilot's decision to taxi the airplane from the roadway and his subsequent failure to maintain clearance from signs and a fence after a successful emergency landing following a total loss of engine power.NTSB CEN17LA062Accident · No injuriesLimited investigationFinal reportPiper PA22 · Piedmont, MOThe pilot’s descent below glidepath, which resulted in the airplane’s impact with power lines.NTSB ERA17FA074Accident · 2 fatalField investigationFinal reportIndependent Technologies Epic LT · Port Orange, FLThe pilot's loss of airplane control due to spatial disorientation, which resulted in the exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's failure to fly a stabilized approach…NTSB ERA17FA072Accident · 1 fatalField investigationFinal reportPiper PA28 · Middlebury, VTThe pilot's improper decision to return to the airport following a partial or complete loss of engine power during takeoff initial climb and his failure to maintain sufficient airspeed while maneuvering, which resulted in exceedance of the critical angle of…NTSB CEN17LA070Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Pontiac, MIThe improper installation of the left wheel brake torque plate by maintenance personnel, which resulted in the separation of the torque plate from the axle endplate and a loss of directional control during landing.NTSB GAA17CA103Accident · Minor injuriesData collectionFinal reportPiper PA28 · Shreveport, LAThe pilot’s inadequate compensation for crosswind conditions during the go-around, which resulted in a loss of airplane control.NTSB CEN17LA060Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Millersburg, OHThe pilot's improper in-flight fuel management and his failure to switch the fuel selector to the “both” position in accordance with the Before Landing checklist, which resulted in a loss of engine power due to fuel starvation.NTSB GAA17CA098Accident · Serious injuriesData collectionFinal reportCessna 182 · Apple Valley, CAThe pilot’s mismanagement of the available fuel, which resulted in a loss of engine power and a subsequent hard, off-airport landing and nose-over.NTSB CEN17LA058Accident · No injuriesLimited investigationFinal reportBellanca 17 30A · Blaine, MNA total loss of engine power due to a lack of crankshaft lubrication to the No. 4 connecting rod journal.NTSB ANC17LA013Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Palmer, AKThe pilot's failure to maintain main rotor revolutions per minute (RPM) during a pinnacle landing, which resulted in a main rotor stall condition, a loss of control, and a subsequent impact with terrain. A contributing factor was the flight instructor's…NTSB ERA17LA070Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Ormond Beach, FLThe pilot's impairment by alcohol before and during the flight, which led to his improper fuel management and resulted in fuel exhaustion and a subsequent loss of engine power.NTSB ANC17FA012Accident · 2 fatalField investigationFinal reportPiper PA 11 · Aniak, AKThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB GAA17CA101Accident · No injuriesData collectionFinal reportMaule MX 7 · Willow, AKThe pilot’s failure to ensure that the runway was clear of any obstacles before departure, which resulted in the airplane impacting a snowdrift.NTSB GAA17CA096Accident · No injuriesData collectionFinal reportPiper PA28 · Madisonville, TNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.NTSB GAA17CA149Accident · No injuriesData collectionFinal reportPiper PA28 · Palm Coast, FLThe pilot’s failure to maintain clearance from the taxiway sign.NTSB WPR17FA035Accident · 1 fatalField investigationFinal reportQuest Kodiak 100 · Moab, UTThe pilot's loss of control shortly after takeoff due to spatial disorientation.NTSB ERA17CA068Accident · Minor injuriesData collectionFinal reportBeech A36 · New Smyrna Beach, FLThe pilot's inappropriate response to an emergency exit window opening in flight, which resulted in a loss of control, precautionary off-airport landing, and subsequent impact with trees. Contributing to the accident was the pilot's improper repair of the…NTSB ERA17LA067Accident · Serious injuriesLimited investigationFinal reportMathias Linda B Lightning · Franklin, VAA partial loss of engine power due to pre-ignition damage to the No. 2 cylinder piston and the pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall.NTSB CEN17LA055Accident · Serious injuriesLimited investigationFinal reportHiller OH 23B · Tynan, TXThe student pilot's delayed and improper landing flare during a practice autorotation, which resulted in the tail rotor striking terrain.NTSB GAA17CA093Accident · No injuriesData collectionFinal reportPiper PA 34 · Denton, TXThe flight instructor’s decision to continue to taxi the airplane to the parking area with a known brake malfunction, which resulted in a loss of directional control and subsequent impact with a parked airplane.NTSB CEN17FA050Accident · 1 fatalField investigationFinal reportCub Crafters PA18 · Basin, WYThe pilot exceeded the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.NTSB ANC17FA009Accident · 1 fatalClass 3 · FieldFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot’s decision to operate the airplane at an altitude too low to allow for recovery from an intentional aerodynamic stall. Contributing to the accident was the pilot’s lack of knowledge of the stall performance characteristics of the airplane modified…NTSB WPR17FA033Accident · 1 fatalField investigationFinal reportAirborne Windsports PTY Edge XT-912-L · Santa Barbara, CAThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern.NTSB WPR17LA032Accident · Minor injuriesLimited investigationFinal reportHoskins Lonnie F Velocity XL RG · Petaluma, CAThe pilot’s failure to maintain adequate airspeed during an aborted landing, which resulted in an exceedance of the airplane’s critical angle of attack and an inadvertent aerodynamic stall. Contributing to the accident was the pilot’s distraction while on…NTSB GAA17CA087Accident · No injuriesData collectionFinal reportJack Fehling Celebrity · North Hampton, NHThe pilot’s unstabilized approach, which resulted in the biplane being low and striking trees.NTSB CEN17WA049Accident · 4 fatalForeign investigationBeech E 90 · Toledo, SpainNTSB CEN17LA048Accident · No injuriesLimited investigationFinal reportArion Lightning LS-1 · Goshen, INA partial loss of engine power due to carburetor icing and the subsequent forced landing on a rough/soft field.NTSB CEN17FA046Accident · 1 fatalField investigationFinal reportGordon Pegazair P 100 · Mt Vernon, INThe pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.NTSB CEN17FA045Accident · 1 fatalField investigationFinal reportCessna 340 · Fargo, NDThe loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire.NTSB GAA17IA083Incident · No injuriesIncident investigationFinal reportCessna 560 · Salinas, CAThe pilot's failure to maintain clearance from a parked helicopter.NTSB WPR17FA029Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Glamis, CAThe pilot's improper decision to attempt a downwind landing and his failure to maintain adequate airspeed while maneuvering during a go-around and subsequent landing attempt, which resulted in exceedance of the airplane's critical angle of attack and an…NTSB WPR17LA038Accident · No injuriesLimited investigationFinal reportCessna 182A · Safford, AZThe total loss of engine power due to the failure of the No. 5 piston, piston pin, or connecting rod assembly for reasons that could not be determined due to the severity of the post fracture damage.NTSB ERA17LA057Accident · No injuriesLimited investigationFinal reportPiper PA28 · Columbus, GAA total loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the airframe and engine revealed no evidence of any anomalies that would have precluded normal operation.NTSB CEN17LA044Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Bridgeport, TXThe pilot's failure to properly position the fuel selector before takeoff, which resulted a total loss of engine power due to fuel starvation.NTSB CEN17LA043Accident · Minor injuriesLimited investigationFinal reportBeech 200 · Moorhead, MNThe pilot's failure to attain a positive climb rate during an attempted missed approach in night instrument meteorological conditions that were at/near approach minimums, which resulted in controlled flight into terrain.NTSB GAA17CA085Accident · No injuriesData collectionFinal reportHundley Michael J Vans RV8 · Roopville, GAThe pilot’s overcorrection with the right rudder during the landing roll, which resulted in a loss of directional control and a runway excursion.NTSB GAA17CA078Accident · No injuriesData collectionFinal reportLancair LC41 550FG · Redding, CAThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB ERA17LA063Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bluefield, WVThe pilot's failure to maintain directional control during the aborted takeoff.NTSB ANC17LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bethel, AKThe mechanic's failure to install a whistle slot in the engine breather tube, which resulted in a frozen tube, displacement of the crankshaft oil seal, a loss of oil, and smoke in the cockpit, which led to a forced landing.NTSB ERA17FA052Accident · 1 fatalField investigationFinal reportRyan Navion · New Gretna, NJThe pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control.NTSB CEN17LA042Accident · Serious injuriesLimited investigationFinal reportNorthwing Navajo · Daingerfield, TXThe noncertificated pilot’s unfamiliarity with the aircraft, which resulted in a loss of control during an unintentional takeoff.NTSB WPR17FA023Accident · 1 fatalField investigationFinal reportCessna 172N · Moss Beach, CAThe pilot's loss of airplane control following an encounter with low level wind shear and turbulence during final approach for landing. Contributing to the loss of control was the pilot's decision to retract the wing flaps on final approach, which resulted in…NTSB GAA17CA081Accident · No injuriesData collectionFinal reportCessna 172 · Destin, FLThe student pilot’s overcorrection with right rudder, which resulted in a loss of directional control, and the flight instructor’s delayed remedial action.