NTSB investigations, 2017
29 cases where NTSB found Dark.
Cases per year
| 2008 | 48 |
|---|---|
| 2009 | 24 |
| 2010 | 19 |
| 2011 | 27 |
| 2012 | 27 |
| 2013 | 25 |
| 2014 | 29 |
| 2015 | 38 |
| 2016 | 23 |
| 2017 | 29 |
| 2018 | 37 |
| 2019 | 28 |
| 2020 | 19 |
| 2021 | 19 |
| 2022 | 13 |
| 2023 | 22 |
| 2024 | 9 |
| 2025 | 11 |
| 2026 | 1 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03036020'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03036020')) 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 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 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 GAA18CA071Accident · No injuriesData collectionFinal reportCessna 402 · Hyannis, MAEncounter with a flock of birds during takeoff at night, resulting in multiple bird strikes and structural damage.NTSB WPR18FA035Accident · 1 fatalField investigationFinal reportCessna 152 · Tehachapi, CAThe pilot's loss of situational awareness shortly after takeoff over a sparsely lit area in dark night conditions, which resulted in a rapid descent to ground impact.NTSB GAA18CA048Accident · Minor injuriesData collectionFinal reportCessna 172M · Chico, CAAn in-flight collision with a bird.NTSB GAA17CA580Accident · No injuriesData collectionFinal reportMooney M20K · Los Lunas, NMThe pilot’s improper glidepath during a night approach, which resulted in impact with terrain short of the runway.NTSB CEN18LA014Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Gustavus, OHThe pilot’s geographic disorientation while maneuvering in the airport traffic pattern in dark night conditions, which resulted in the airplane descending below a normal approach path and a collision with trees. Contributing to the accident was the pilot's…NTSB CEN18FA009Accident · 2 fatalField investigationFinal reportCessna 182H · Las Cruces, NMControlled flight into terrain in dark night conditions.NTSB GAA18CA007Accident · No injuriesData collectionFinal reportCessna T210 · Waterford, MIThe pilot's unstabilized approach at night, which resulted in collision with trees.NTSB WPR17FA215Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Brinnon, WAThe flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into…NTSB GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.NTSB ERA17FA330Accident · 1 fatalField investigationFinal reportCessna 150G · Rhine, GAThe student pilot's decision to take off from a partially-lit grass runway in dark night, marginal visual flight rules conditions, which resulted in spatial disorientation, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall.NTSB CEN17LA350Accident · No injuriesLimited investigationFinal reportEmbraer EMB 120ER · Greeley, COThe bus driver's failure to maintain clearance from the standing airplane during dark night conditions. Contributing to the accident was the airport's lack of an escort for the bus.NTSB ANC17FA049Accident · 1 fatalField investigationFinal reportPiper PA-18AS · Tyonek, AKThe noninstrument-rated pilot's decision to initiate a visual flight rules flight into dark night, marginal visual flight rules to instrument flight rules conditions, which resulted in a loss of control due to spatial disorientation.NTSB ERA17LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJThe student pilot's improper decision to conduct a night flight and his failure to maintain adequate altitude during the approach, which resulted in controlled flight into trees and terrain. Contributing to the accident was the student pilot's lack of total…NTSB GAA17CA452Accident · No injuriesData collectionFinal reportPiper PA28 · St. Joseph, ILThe pilot’s improper landing flare, which resulted in the nose landing gear collapsing and subsequent loss of directional control.NTSB CEN17LA282Accident · Serious injuriesLimited investigationFinal reportBeech G35 · Wichita Falls, TXThe flight's encounter with adverse weather conditions at night, which resulted in the pilot's loss of airplane control upon landing due to standing water and a subsequent runway overrun.NTSB ERA17FA231Accident · 1 fatalField investigationFinal reportCessna 152 · Homestead, FLThe pilot's loss of control due to spatial disorientation while maneuvering in night conditions over an area devoid of ground reference lights.NTSB CEN17FA227Accident · 2 fatalField investigationFinal reportBeech E 90 · Ruidoso, NMThe pilot's failure to maintain clearance from terrain after takeoff during dark night conditions.NTSB CEN17FA168Accident · 3 fatalClass 2 · FieldFinal reportPilatus PC 12 · Amarillo, TXThe pilot's loss of airplane control due to spatial disorientation during the initial climb after takeoff in night instrument meteorological conditions and moderate turbulence.NTSB GAA17CA235Accident · No injuriesData collectionFinal reportRaytheon B200 · Richfield, UTThe pilot’s failure to maintain separation from a fence post during taxi at night.NTSB WPR17LA092Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Whittier, CAThe pilot's impaired decision-making due to alcohol intoxication and his improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA17FA139Accident · 2 fatalField investigationFinal reportMooney M20J · Aberdeen, MSThe pilot's failure to maintain clearance from terrain after takeoff in dark night conditions for reasons that could not be determined based on the available information.NTSB ANC17FA018Accident · 1 fatalField investigationFinal reportCessna R172K · Nome, AKThe pilot's improper decision to conduct multiple visual approaches to the destination airport despite the night instrument meteorological conditions; the airplane's low fuel state at that time, which resulted in a total loss of engine power due to fuel…NTSB ERA17FA118Accident · 1 fatalField investigationFinal reportCessna 421 · Canton, GAThe pilot's failure to maintain control of the airplane during a night visual landing approach. Contributing to the accident was the pilot's impairment due to his use of a combination of medications.NTSB GAA17CA172Accident · No injuriesData collectionFinal reportCessna 182 · Alpine, TXThe pilot’s inadequate compensation for gusting crosswind conditions at night and his delayed go-around, which resulted in the airplane bouncing and impacting a fence.NTSB WPR17FA065Accident · 3 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's inadequate preflight weather planning and his poor decision-making.NTSB ERA17FA107Accident · 1 fatalField investigationFinal reportBeech A45 · Climax, GAThe failure of maintenance personnel to ensure that the throttle and fuel metering unit AN "B" nut was secured, which resulted in a total loss of engine power in flight and a subsequent collision with trees while attempting to land after sunset.NTSB CEN17FA103Accident · 2 fatalField investigationFinal reportBell Helicopter Textron Canada 429 · Shreveport, LAThe pilot's inadvertent encounter with instrument meteorological conditions resulting in spatial disorientation, loss of control, and subsequent impact with terrain.