NTSB investigations, 2008
68 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\") = 2008
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") = 2008 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 ERA09FA116Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Pittstown, NJThe pilot's failure to maintain an adequate clearance from trees during the night landing approach and the flight instructor's inadequate remedial action.NTSB ERA09CA117Accident · No injuriesData collectionFinal reportBeech G35 · Chattanooga, TNThe pilot's failure to see and avoid the marked helicopter dolly. Contributing to the accident were the dark night conditions.NTSB WPR09FA068Accident · No injuriesField investigationFinal reportBoeing 757-351 · Seattle, WAThe failure of the tug operator and wing walker of the other airplane to maintain clearance with this aircraft during the pushback process in dark night. Also causal was the ramp controller's misinterpretation of the other airplane's gate location and her…NTSB ERA09FA092Accident · 1 fatalField investigationFinal reportCessna 172S · Goodland, FLThe pilot's failure to maintain aircraft control due to spatial disorientation. Contributing to the accident was the night light conditions.NTSB WPR09LA050Accident · 1 fatalLimited investigationFinal reportBeech A36 · Coalinga, CAThe loss of engine power while in climb to cruise flight for undetermined reasons.NTSB CEN09CA071Accident · No injuriesData collectionFinal reportCessna 150F · Trenton, TXThe pilot's improper flare during landing, resulting in a hard landing. Contributing to the accident were the night light conditions and the instructor's inadequate supervision of the pilot.NTSB ERA09LA064Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Groton, CTThe student pilot’s failure to maintain a proper descent profile to avoid trees during the night visual approach and the flight instructor’s inadequate oversight.NTSB ERA09FA060Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIThe pilot's improper descent below the published minimum descent altitude during the approach, which resulted in controlled flight into terrain.NTSB CEN09LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Downers Grove, ILThe pilot's failure to maintain a proper glidepath while on final approach in night conditions, due to his impairment from recent use of alcohol, cocaine, and over-the-counter and prescription medications.NTSB DCA09FA011Accident · Minor injuriesField investigationFinal reportBombardier CL-600-2B19 · Detroit, MIThe lack of vigilance on the part of the ramp agent driving the baggage tug. Contributing factors include the night conditions, and low visibility due to fog and rain.NTSB ERA09FA036Accident · 1 fatalField investigationFinal reportRobinson R-44 · Gallatin, TNThe pilot's inadvertent descent into water as a result of the dark night and limited outside visual references.NTSB WPR09FA027Accident · 2 fatalField investigationFinal reportCessna P206 · Estacada, ORThe pilot's failure to maintain clearance from trees while on approach to land at night. Contributing to the accident was the electrical system failure and the pilot's diverted attention.NTSB ERA09FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Selmer, TNThe pilot's failure to avoid terrain during night instrument meteorological conditions.NTSB WPR09LA022Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Concrete, WAThe loss of engine power during initial climb due to the pilot's improper exhaust system maintenance, which resulted in restriction of the carburetor's air intake.NTSB CEN09LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Whitewater, COBoth pilots' failure to see and avoid the other airplane. Contributing factors in this accident were the Cessna 180 pilot's attention being diverted and the Cessna 210 pilot's vision being affected by the sun glare.NTSB CEN09CA026Accident · Minor injuriesData collectionFinal reportHolland Rotorway 162F · Rutland, SDThe loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.NTSB WPR09CA006Accident · No injuriesData collectionFinal reportCessna 210-5(205) · Payson, UTThe total loss of engine power during cruise flight for undetermined reasons. Contributing to the accident were a dark night and a cherry orchard at the location where the pilot executed the forced landing.NTSB CEN09CA004Accident · No injuriesData collectionFinal reportCessna 182P · Mount Vernon, MOThe pilot failed to maintain a proper landing aim point. Contributing to the accident were the setting sun and the uneven terrain approaching the runway.NTSB ERA09CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Chester, CTThe pilot’s failure to obtain the proper touchdown point while landing. Contributing to the accident were the pilot’s inexperience landing at the airport, night conditions, and non-standard runway lighting.NTSB NYC08FA324Accident · 1 fatalField investigationFinal reportCessna 402 · Vineyard Haven, MAA loss of aircraft control due to spatial disorientation.NTSB CHI08FA293Accident · 2 fatalField investigationFinal reportRobinson R44 II · Kenosha, WIThe pilots failure to maintain clearance from terrain resulting in an in-flight collision with a house. Contributing to the accident was the night instrument meteorological conditions (IMC) and the pilot's lack of experience of flying in IMC.NTSB CHI08CA285Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Lakeville, MNThe pilot's lack of clearance from the approach lights and the distraction of those bright approach lights during his night approach.NTSB CHI08CA278Accident · No injuriesData collectionFinal reportCessna 185 · Newberry, MIThe pilot's failure to maintain clearance from the wires on approach. Contributing to the accident was the sunshine, as reported by the pilot.NTSB SEA08LA191Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Burbank, CAThe pilot's improper preflight and in-flight planning, which resulted in fuel exhaustion. Contributing to the accident were the pilot's loss of situational awareness while conducting the normal and emergency checklists during his turn from base to final…NTSB CHI08CA263Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Greenville, MIThe deer that ran onto the runway contacting the airplane. A factor associated with the accident was the dark night conditions.NTSB CHI08CA261Accident · Minor injuriesData collectionFinal reportNtbk Wag Aero Sport · Oxford, IAThe pilot misjudged his approach path which resulted in insufficient altitude and the subsequent failure to maintain clearance with the trees. Contributing to the accident were the trees and the dusk lighting conditions.NTSB LAX08FA261Accident · 1 fatalField investigationFinal reportCessna 172S · Incline Village, NVThe pilot's decision to initiate a flight for which he was neither approved nor qualified and his failure to maintain terrain clearance during the flight. Contributing to the accident were the dark night, the mountainous terrain, and the pilot's medical…NTSB CHI08CA235Accident · Minor injuriesData collectionFinal reportCessna 150L · Watertown, SDThe pilot's failure to maintain altitude/clearance from terrain during cruise. Contributing to the accident was the night, the haze, and the tall vegetation.NTSB CHI08CA223Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Ambia, INThe altitude/clearance not obtained/maintained by the pilot while maneuvering over an agricultural field during an aerial application. Contributing factors were the sunglare in the direction of flight, the low altitude of the operation, and the upslope of the…NTSB MIA08CA143Accident · No injuriesData collectionFinal reportCessna TR182 · Factoryville, PAThe pilot's diverted attention while on final approach and his delay in performing a go-around during the landing roll. Contributing to the accident were sun glare and excessive airspeed.NTSB LAX08CA229Accident · No injuriesData collectionFinal reportBell 47G-3B-1 · Shafter, CAThe pilot's failure to maintain adequate altitude while maneuvering. Contributing factors were the failure of the helicopter's lights during the night flight and the effect of that failure on the pilot's visual perception.NTSB ANC08LA088Accident · No injuriesLimited investigationFinal reportCessna 150 · Manley Hot Spgs, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with a ditch during the takeoff roll. Factors contributing to the accident were low light conditions at dusk, and soft terrain.NTSB LAX08CA223Accident · Minor injuriesData collectionFinal reportGrumman Acft Eng G-164B · Patterson, CAThe pilot's failure to maintain clearance from obstacles while maneuvering.NTSB CHI08CA178Accident · No injuriesData collectionFinal reportMooney M20K · Howell, MIThe collision with a deer during the takeoff roll. Contributing to the accident was the dusk light condition.NTSB LAX08LA213Accident · 2 fatalLimited investigationFinal reportSchweizer 269 C-1 · Sunol, CAThe pilots' failure to maintain adequate clearance from transmission wires during cruise flight. Contributing to the accident were the dark night and low fog.NTSB LAX08LA198Accident · Serious injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Ash Fork, AZThe pilot's spatial disorientation resulting in his failure to detect and compensate for an unintentional descent during a go-around. Contributing to the accident were the pilot's inadequate choice of landing approach, reduced visibility from brownout…NTSB LAX08CA186Accident · No injuriesData collectionFinal reportAlon A2 · Sandpoint, IDThe airplane struck a deer on the runway while performing touch-and-go landings. Contributing to the accident was the dusk light condition.NTSB DEN08CA117Accident · No injuriesData collectionFinal reportCessna T182T · Omaha, NEThe pilot's improper use of the elevator trim resulting in a nose low/hard landing.NTSB DEN08FA101Accident · 4 fatalField investigationFinal reportBell 407 · Huntsville, TXThe pilot's failure to identify and arrest the helicopter's descent, which resulted in its impact with terrain. Contributing to the accident was the limited outside visual reference due to the dark night conditions.NTSB MIA08FA115Accident · 3 fatalField investigationFinal reportCessna T206H · Cedar Key, FLThe pilot’s failure to maintain clearance from the water during a dark night approach to a coastal airport.NTSB NYC08CA200Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Wildwood, NJThe pilot's failure to maintain clearance from trees during approach. Contributing to the accident were the dark night conditions.NTSB CHI08CA131Accident · Minor injuriesData collectionFinal reportKuntz Kuntz 2000 GTS EFI · Dickinson, NDThe pilot's inadequate preflight weather evaluation and the unsuitable terrain encountered during the precautionary landing at night. Contributing to the accident was the pilot becoming lost after inadvertently encountering fog while en route, the night…NTSB LAX08LA127Accident · No injuriesLimited investigationFinal reportCessna 182H · Prescott, AZA loss of engine power from fuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB SEA08CA121Accident · No injuriesData collectionFinal reportExtra Flugzeugbau EA300/L · Great Falls, MTThe pilot's misjudged landing flare. A contributing factor was the glare from the sun.NTSB CHI08LA101Accident · 2 fatalLimited investigationFinal reportCessna 172K · Roseglen, NDThe pilot failed to maintain obstacle clearance from the TV antenna during a low altitude maneuver. Contributing factors were the antenna, the night conditions, and pilot impairment due to alcohol.NTSB SEA08FA108Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Big Bear City, CAThe pilot's failure to maintain altitude/clearance from mountainous terrain. Contributing to the accident were the mountainous terrain, the dark night condition, the turbulent wind condition, and the low clouds.NTSB DFW08TA092Accident · No injuriesFinal reportRobinson R44 · Topeka, KSA malfunctioning magneto, resulting in a high engine rpm and low rotor warning indications. A contributing factor was the impact with a light pole, during the precautionary landing.NTSB LAX08FA092Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Benson, AZThe pilot's misjudged speed and altitude during approach that led to a long landing and his subsequent failure to maintain control during an attempted go-around. Contributing to the accident were the dark night, the pilot's low total night flight experience,…NTSB ANC08LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Koliganek, AKThe pilot's VFR flight into adverse weather conditions that resulted in a collision with snow-covered terrain during a turn to reverse direction. Factors contributing to the accident were low ceilings, flat lighting conditions, and the snow-covered terrain.NTSB SEA08LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bridger, MTThe pilot failed to maintain situational awareness during the flight. Contributing to the accident were the dark night, the pilot's failure to follow approved navigational procedures for the flight, and the pilot's over reliance on the avionics in the…