NTSB investigations, 2017
43 cases where NTSB found Light condition.
Cases per year
| 2008 | 68 |
|---|---|
| 2009 | 43 |
| 2010 | 30 |
| 2011 | 44 |
| 2012 | 40 |
| 2013 | 36 |
| 2014 | 37 |
| 2015 | 46 |
| 2016 | 41 |
| 2017 | 43 |
| 2018 | 46 |
| 2019 | 35 |
| 2020 | 31 |
| 2021 | 26 |
| 2022 | 27 |
| 2023 | 31 |
| 2024 | 23 |
| 2025 | 21 |
| 2026 | 3 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030360'))
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", '030360')) 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 GAA18CA087Accident · No injuriesData collectionFinal reportMaule MX7 · Willow, AKThe pilot’s failure to see and avoid another airplane stopped on the taxiway while taxiing in sun glare conditions.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 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 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 GAA18CA069Accident · No injuriesData collectionFinal reportWeaver David A Pulsar 912XP · Plato Center, ILThe pilot’s decision to continue to land without visual reference to the airport in low light conditions. Contributing to the accident was the pilot’s inability to activate the private airport’s pilot-controlled lighting system due to its configuration.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 GAA18CA063Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAAn in-flight collision with a bird.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 GAA18CA015Accident · Minor injuriesData collectionFinal reportThomas G Parkhurst Kitfox IV · Sidney, NYThe pilot's exceedance of the airplane’s critical angle of attack following a loss of ground reference during landing in glaring sun conditions, which resulted in an aerodynamic stall/spin.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 CEN18FA011Accident · 2 fatalField investigationFinal reportCessna 172M · Ramsey, MNThe pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…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 CEN17CA345Accident · No injuriesData collectionFinal reportShiner RV-4 · Ramah, NMThe pilot’s failure to maintain clearance from berms during landing in sun glare conditions.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 GAA17CA474Accident · No injuriesData collectionFinal reportCessna 210 · Bettles, AKThe pilot's failure to maintain an appropriate glidepath during the approach to the runway over glassy water and in glaring sun conditions.NTSB GAA17CA421Accident · No injuriesData collectionFinal reportAviat A 1 · Dixie, IDThe pilot's failure to maintain an appropriate glidepath to landing with sun glare and downdraft conditions, which resulted in the airplane landing in a ravine short of the runway.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 GAA17CA225Accident · No injuriesData collectionFinal reportWeatherly 620B · Lewistown, MTThe pilot’s failure to maintain altitude during low-altitude maneuvers in flat light conditions.NTSB GAA17CA241Accident · Minor injuriesData collectionFinal reportAmerican AA 1 · New Market, VAThe pilot’s failure to maintain a proper approach path, which resulted in an impact with trees.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 GAA17CA160Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot’s failure to maintain clearance from a hangar while taxiing at night.NTSB GAA17CA147Accident · No injuriesData collectionFinal reportCessna A185 · Fairbanks, AKThe pilot's failure to maintain an appropriate glidepath to the runway and to use the vertical guidance system.NTSB GAA17CA187Accident · No injuriesData collectionFinal reportPiper PA22 · Ruby, AKThe pilot’s failure to maintain directional control while landing in flat light conditions on a hard-packed snow-covered landing area.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.