NTSB investigations, 2017
42 cases where the defining event was Miscellaneous/other.
Cases per year
| 2008 | 26 |
|---|---|
| 2009 | 27 |
| 2010 | 39 |
| 2011 | 52 |
| 2012 | 66 |
| 2013 | 48 |
| 2014 | 41 |
| 2015 | 39 |
| 2016 | 56 |
| 2017 | 42 |
| 2018 | 54 |
| 2019 | 36 |
| 2020 | 31 |
| 2021 | 18 |
| 2022 | 27 |
| 2023 | 27 |
| 2024 | 33 |
| 2025 | 54 |
| 2026 | 22 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '900')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '900') 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 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 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 GAA18CA044Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot’s failure to see and avoid power lines while maneuvering at a low altitude.NTSB CEN18FA023Accident · 2 fatalField investigationFinal reportBeech V35B · Alva, OKThe flight instructor's and pilot's failure to recognize that a high descent rate had developed on short final, likely due to their distraction by an open engine cowling, and the unexpected strong pitch-down force during flap extension due to the installation…NTSB GAA18CA034Accident · No injuriesData collectionFinal reportAirbus Helicopters EC 130 · La Paloma, TXThe separation of a weight from the gunner’s net, which struck the helicopter’s main rotor blade during flight.NTSB GAA18CA029Accident · Serious injuriesData collectionFinal reportSix Chuter West Legend XL · Mabton, WAThe pilot’s failure to see and avoid transmission wires.NTSB WPR18LA012Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22T · San Carlos, CAThe pilot's failure to follow the Before-Takeoff checklist and properly set the flaps before takeoff, which altered the airplane’s flight characteristics, and the pilot’s failure to recognize the problem and abort the takeoff in a timely manner, which…NTSB ENG18WA038Incident · No injuriesForeign investigationEmbraer ERJ190 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an incident involving an Embraer 190-200 LR, which occurred on October 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…NTSB GAA17CA563Accident · No injuriesData collectionFinal reportPiper PA 22 · Orangeburg, SCA failed main landing gear tire for reasons that could not be determined due to postcrash fire damage.NTSB ERA17WA342Accident · 1 fatalForeign investigationRobinson R44 · Cape Town, South AfricaOn September 28, 2017, about 1000 coordinated universal time, a Robinson R44 II helicopter, South African registration ZS-OSL, was destroyed when it impacted terrain during an emergency autorotation near Cape Town, South Africa. The pilot was fatally injured.…NTSB DCA17WA216Incident · No injuriesForeign investigationBoeing 737 · Luga, MaltaThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…NTSB ERA17WA323Accident · 1 fatalForeign investigationBritten Norman BN2A · San Salvador de Paul, VenezuelaOn September 11, 2017 about 1400 coordinated universal time, a Britten Norman BN2-A, Venezuelan registration YV1441, was landing at San Salvador de Paul, Ciudad Bolivar, Venezuela, when it struck and fatally injured a child who was on the runway. The pilot…NTSB ANC17LA051Accident · No injuriesClass 3 · LimitedFinal reportLeonardo AW139 · Tujunga, CAA yaw excursion and uncontrolled descent due to loss of tail rotor effectiveness during aerial firefighting operations resulting in an impact with trees. A contributing factor was the pilot’s failure to maintain sufficient airspeed, coupled with a quartering…NTSB GAA17CA537Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Foley, ALThe ground crew’s incorrect hook up of the banner, which resulted in a nose-over.NTSB ERA17LA290Accident · No injuriesLimited investigationFinal reportCessna 180 · Newport, NHA leak in the right brake slave cylinder, which led to no fluid in the reservoir and subsequent asymmetric braking.NTSB WPR17LA183Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 28R-200 · West Jordan, UTThe pilot's failure to account for operation at high density altitude at or near the airplane’s maximum gross weight, which led to degraded engine performance and prevented the airplane from achieving an adequate airspeed for a positive rate of climb,…NTSB WPR17FA171Accident · 2 fatalField investigationFinal reportCessna 172N · Big Bear, CAThe pilot's exceedance of the airplane's critical angle of attack during takeoff in high density altitude conditions, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.NTSB CEN17CA294Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502B · Harrold, SDThe pilot’s improper attempt at a low-pass maneuver, which resulted in a collision with a tractor.NTSB WPR17LA163Accident · Minor injuriesClass 3 · LimitedFinal reportBritish BAC Stkmstr MK80 · Henderson, NVThe failure of the pilot to ensure that the flaps were set to the proper position for takeoff which resulted in the airplane becoming airborne and unable to climb or accelerate and subsequently impacting terrain.NTSB GAA17CA437Accident · No injuriesData collectionFinal reportCessna 172 · Powell, WYThe student pilot’s improper landing flare and subsequent failure to relinquish the flight controls, which resulted in a hard landing.NTSB GAA17CA574Accident · No injuriesData collectionFinal reportCessna 208 · New York, NYThe airplane’s encounter with boat wake and multiple swells during a water takeoff.NTSB ERA17WA259Accident · 2 fatalForeign investigationCirrus Design SR20 · Santo Antonio do Leverger, BrazilOn July 20, 2017, at 1109 coordinated universal time, a Cirrus SR-20, Brazilian registration PR-PRF, was substantially damaged when it collided with terrain shortly after takeoff from Santa Edwiges farm, near the municipality of Santo Antônio do Leveger, Mato…NTSB GAA17CA438Accident · No injuriesData collectionFinal reportPiper PA28 · New Market, VAThe airplane’s collision with a deer during the landing roll.NTSB CEN17LA284Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Reyno, ARThe pilot’s inadvertent use of the propeller control, which caused the propeller to feather while in flight with the engine still operating, resulting in a loss of thrust and a subsequent forced landing.NTSB GAA17CA355Accident · No injuriesData collectionFinal reportBell UH1B · Williams, CAThe pilot’s failure to maintain clearance from transmission wires while maneuvering at a low altitude during an agricultural application flight.NTSB GAA17CA317Accident · No injuriesData collectionFinal reportCessna 177 · Guttenberg, IAThe pilot’s failure to maintain an adequate approach path, which resulted in the left wing impacting a street sign.NTSB DCA17WA138Incident · No injuriesForeign investigationBoeing 737 · Lima, PeruThe Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…NTSB GAA17CA344Accident · No injuriesData collectionFinal reportEurocopter EC130 · Peach Springs, AZThe ground crewman’s failure to hold onto the passenger door while the main rotor was still rotating, which resulted in the door separating from the helicopter and damaging the main rotor.NTSB WPR17LA104Accident · Minor injuriesClass 3 · LimitedFinal reportEvolution Air Lancair Evolution · Firebaugh, CAA failure in the windshield, frame, or windshield-to-frame bond, which resulted in a rapid decompression during cruise flight.NTSB GAA17CA282Accident · No injuriesData collectionFinal reportPiper PA23 · Fremont, OHThe pilot’s failure to maintain an adequate glidepath during approach, which resulted in an impact with a semi-truck.NTSB CEN17LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Beech Grove, ARA tire failure for reasons that could not be determined, which resulted in a loss of directional control during takeoff.NTSB GAA17CA265Accident · No injuriesData collectionFinal reportRotorcraft Development OH-58A+ · Waterloo, ILThe pilot’s failure to see and avoid transmission wires while maneuvering at a low altitude.NTSB ERA17FA172Accident · 1 fatalField investigationFinal reportPiper PA31 · Colton, NYThe pilot's incapacitation for unknown reasons, which resulted in an overflight of his destination, a subsequent loss of engine power due to fuel starvation, and collision with terrain.NTSB CEN17FA164Accident · 2 fatalField investigationFinal reportBellanca 17 31ATC · Boonville, MOThe pilot's impairment, due to his use of a combination of psychoactive drugs and a vision deficiency in his left eye, which resulted in a failure to maintain adequate altitude during final approach to landing and subsequent collision with power lines.NTSB ERA17LA163Accident · No injuriesLimited investigationFinal reportRobinson R44 · Orlando, FLA partial failure of the helicopter's engine tachometer due to the separation of one of the magnet assemblies and engine roughness, which precipitated the pilot’s initiation of an off-airport autorotation, during which he applied improper aft cyclic flight…NTSB GAA17CA235Accident · No injuriesData collectionFinal reportRaytheon B200 · Richfield, UTThe pilot’s failure to maintain separation from a fence post during taxi at night.NTSB ERA17LA141Accident · No injuriesLimited investigationFinal reportCessna R182 · Mooresville, NCThe pilot's failure to properly configure the airplane's flaps for takeoff, which resulted in a longer ground roll and subsequent runway excursion.NTSB GAA17CA197Accident · No injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot’s failure to complete the landing checklist and to extend the landing gear before touchdown.NTSB GAA17CA185Accident · No injuriesData collectionFinal reportPipistrel Doo Ajdovscina Virus · Okmulgee, OKThe pilot’s failure to review the Federal Aviation Administration chart supplement before landing, which resulted in his landing on a closed runway and collision with a fence. Contributing to the accident was the airport’s failure to adequately mark the…NTSB DCA17WA121Incident · No injuriesForeign investigationBoeing 737 · Sint Maarten, NTThe government of Netherlands Antilles has notified the NTSB of an accident involving a BOEING 737 that occurred on March 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands Antilles's investigation under…NTSB WPR17LA064Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Stevensville, MTThe pilot's decision to conduct a takeoff with a tailwind on an upsloping runway in an overweight airplane, which resulted in the airplane having insufficient energy to climb out of ground effect.NTSB CEN17LA101Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Ellendale, MNThe pilot’s incapacitation from carbon monoxide poisoning in flight due to cracks in the exhaust muffler, which resulted in the airplane’s continued flight until it ran out of fuel and its subsequent collision with terrain.