NTSB investigations, 2010
30 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
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\") = 2010
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") = 2010 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 WPR11LA076Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · College Place, WAThe pilot's failure to abort the landing when he lost sight of the runway due to sun glare, and his inadequate compensation for the crosswind.NTSB ERA11FA085Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 40 · Pearlington, MSThe pilot’s controlled flight into terrain likely due to spatial disorientation, while flying over sparsely lighted terrain at night.NTSB ERA11FA074Accident · 1 fatalField investigationFinal reportBeech A36 · Theodore, ALThe pilot's failure to maintain aircraft control while maneuvering at night in deteriorating weather conditions due to spatial disorientation. Contributing to the accident was the pilot's failure to obtain a weather briefing.NTSB ERA11FA070Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Destin, FLControlled flight into water due to the pilot's improper descent below the published minimum descent altitude.NTSB CEN11FA075Accident · 1 fatalField investigationFinal reportHawker-Beechcraft A36 · Oklahoma City, OKThe pilot’s loss of control of the airplane during night instrument meteorological conditions, likely due to spatial disorientation.NTSB ERA11CA072Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Andover, NJAn inadvertent collision with a deer on the runway during a night landing.NTSB ERA11FA055Accident · 2 fatalField investigationFinal reportMooney M20F · Copake, NYThe pilot's failure to monitor and maintain clearance from mountainous terrain during a visual descent to the destination airport at night, which resulted in controlled flight into terrain.NTSB ERA11WA086Accident · 1 fatalForeign investigationEurocopter AS 350 B2 · Taltal, ChileOn November 6, 2010, at 2330 universal coordinated time, a Eurocopter, AS 350 B2 helicopter, Chilean registration CC-AAN, collided with terrain while in low level cruise flight near Taltal, Chile. The flight was operated by Servicios y Transporte Aereos…NTSB WPR11CA036Accident · Minor injuriesData collectionFinal reportAerostar Acft Corp Of Texas M20E · Seligman, AZThe pilot's failure to maintain clearance from terrain while maneuvering. Contributing to the accident was the pilot's inadequate preflight and in-flight planning.NTSB ERA11CA027Accident · No injuriesData collectionFinal reportPiper PA28 · Titusville, FLAn inadvertent collision with a deer during a night takeoff.NTSB CEN10LA556Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Duluth, MNThe pilot's failure to identify and arrest the helicopter's descent due to spatial disorientation.NTSB CEN10CA539Accident · No injuriesData collectionFinal reportCessna A185F · Rushville, NEThe pilot's failure to maintain directional control of the airplane during takeoff. Contributing to the accident was the loss of visual reference due to the sun glare.NTSB ERA10LA421Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Key West, FLThe non-instrument-rated pilot's spatial disorientation during night, over-water, low-ambient-light conditions, which resulted in the airplane impacting the ocean.NTSB ERA10FA414Accident · 2 fatalField investigationFinal reportCessna 172 · Orange, MAThe pilots did not maintain control of the airplane during a flight in dark night conditions due to spatial disorientation.NTSB CEN10CA445Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Zwingle, IAThe pilot's failure to maintain clearance from wires during the agricultural flight.NTSB WPR10CA367Accident · No injuriesData collectionFinal reportCessna 152 · Ephrata, WAThe pilot's failure to maintain clearance from a fire hydrant while taxiing to the runway.NTSB CEN10FA392Accident · 3 fatalField investigationFinal reportBeech 35C33 · Tolar, TXThe pilot's failure to maintain control of the airplane while maneuvering at night over a rural area, due to spatial disorientation.NTSB CEN10CA395Accident · No injuriesData collectionFinal reportBell OH-58A · Roswell, NMThe pilot's failure to maintain clearance from transmission wires.NTSB WPR10CA322Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Sequim, WAThe pilot’s failure to maintain directional control during landing due to an encounter with sun glare.NTSB WPR10FA305Accident · 1 fatalField investigationFinal reportHawker Beechcraft A36 · Seligman, AZThe pilot's failure to maintain clearance from mountainous terrain in the dark night.NTSB ERA10CA309Accident · No injuriesData collectionFinal reportAir Tractor AT-402B · Alcolu, SCThe pilot’s failure to maintain clearance from a tree. Contributing to the accident was the sunglare.NTSB CEN10FA299Accident · 1 fatalField investigationFinal reportBeech G35 · Marble, COThe pilot’s miscalculation of the airplane's turn radius and climb capabilities at high altitude, resulting in controlled flight into terrain. Contributing to the accident was the pilot's lack of mountain flying experience and restricted visibility due to the…NTSB ANC10CA040Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Seward, AKThe pilot's failure to maintain clearance from snow-covered terrain while hovering in flat light conditions, which resulted in a dynamic rollover.NTSB WPR10FA228Accident · 1 fatalField investigationFinal reportCessna U206G · Yuma, AZThe pilot's loss of situational awareness and failure to maintain aircraft control while maneuvering at low altitude. Contributing to the accident was glare from the rising sun.NTSB CEN10CA237Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Houston, TXThe pilot's failure to attain the proper touchdown point which resulted in an overrun.NTSB WPR10FA158Accident · 1 fatalField investigationFinal reportBeech K35 · Boulder City, NVA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management; also causal was his subsequent failure to maintain clearance from power lines.NTSB WPR10FA142Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Groveland, CAThe pilot's continued flight into night instrument meteorological conditions during the landing approach, which resulted in an in-flight loss of aircraft control due to spatial disorientation.NTSB CEN10FA113Accident · 3 fatalField investigationFinal reportAerospatiale AS350 · El Paso, TXThe pilot's loss of situational awareness resulting in controlled flight into terrain. Contributing to the accident was the pilot's unfamiliarity with the hazards of a low-contrast area while using night vision goggles.NTSB ERA10CA114Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Collegedale, TNThe pilot’s failure to maintain directional control during the initial climb after takeoff in dark light conditions.NTSB CEN10CA092Accident · Minor injuriesData collectionFinal reportCessna 150L · Brownstown, ILA total loss of engine power due to fuel exhaustion as a result of the student pilot becoming lost/disoriented in flight.