NTSB investigations, 2014
45 cases where NTSB found Ceiling/visibility/precip.
Cases per year
| 2008 | 67 |
|---|---|
| 2009 | 64 |
| 2010 | 69 |
| 2011 | 63 |
| 2012 | 53 |
| 2013 | 52 |
| 2014 | 45 |
| 2015 | 49 |
| 2016 | 42 |
| 2017 | 54 |
| 2018 | 36 |
| 2019 | 56 |
| 2020 | 36 |
| 2021 | 44 |
| 2022 | 33 |
| 2023 | 32 |
| 2024 | 27 |
| 2025 | 5 |
| 2026 | 2 |
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\") = 2014
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030350'))
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") = 2014 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030350')) 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 CEN15FA092Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Vaughn, NMThe noninstrument-rated pilot’s continued flight into night instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain.NTSB WPR15FA070Accident · 2 fatalField investigationFinal reportCessna 172 · Sutter Creek, CAThe noninstrument-rated pilot's encounter with instrument meteorological conditions (IMC) while maneuvering, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot's decision to attempt to…NTSB CEN15FA087Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Port Huron, MIThe pilot’s decision to continue flight below the minimum descent altitude without visually acquiring the runway and his delayed and improperly executed missed approach procedure in instrument meteorological conditions.NTSB CEN15FA081Accident · 1 fatalField investigationFinal reportBeech V35A · Seagoville, TXThe pilot’s loss of control and subsequent impact with terrain in instrument meteorological conditions.NTSB DCA15MA029Accident · 6 fatalClass 1 · MajorFinal reportEmbraer EMB-500 · Gaithersburg, MDthe pilot's conduct of an approach in structural icing conditions without turning on the airplane's wing and horizontal stabilizer deice system, leading to ice accumulation on those surfaces, and without using the appropriate landing performance speeds for…NTSB ERA15FA066Accident · 1 fatalField investigationFinal reportPiper PA28 · Sommerville, TNThe noninstrument-rated pilot's improper decision to attempt visual flight in instrument meteorological conditions, which resulted in an in-flight loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s impaired…NTSB CEN15LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-250 · Berrien Springs, MIThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15FA051Accident · 2 fatalField investigationFinal reportMooney M20C · Pagosa Springs, COThe noninstrument-rated pilot's improper decision to fly to the destination airport and into known instrument meteorological conditions, which resulted in his controlled flight into mountainous terrain during a snow storm.NTSB CEN15FA044Accident · 1 fatalField investigationFinal reportMooney M20K · Clines Corners, NMThe noninstrument-rated pilot's decision to initiate the flight into known deteriorating weather conditions and his continued visual flight into instrument meteorological conditions, which ultimately resulted in a loss of airplane control. Contributing to the…NTSB CEN15FA040Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Grover Hill, OHThe airplane's encounter with supercooled large droplet (SLD) icing, which resulted in a loss of lift and a subsequent uncontrolled descent into terrain. Also causal was the pilot's preflight and in-flight decision to fly in known icing conditions in an…NTSB CEN15FA027Accident · 1 fatalField investigationFinal reportCessna T210M · Bay City, WIThe non-instrument rated pilot’s continued visual flight into instrument flight rules conditions, which resulted in an in-flight loss of control.NTSB CEN15FA009Accident · 3 fatalField investigationFinal reportRaytheon 58 · Palos Hills, ILThe pilot's loss of airplane control due to spatial disorientation while operating in night, instrument meteorological conditions.NTSB CEN14FA506Accident · 1 fatalField investigationFinal reportCessna 172R · Okmulgee, OKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance with trees and terrain.NTSB ERA14LA433Accident · Serious injuriesLimited investigationFinal reportPiper J3C 65 · Carrol County, VAThe pilot’s failure to maintain clearance from trees during an emergency landing after encountering deteriorating weather conditions. Contributing to the accident was the pilot’s poor preflight weather planning, which resulted in an inadvertent encounter with…NTSB CEN14CA512Accident · No injuriesData collectionFinal reportChampion 7GCAA · Alpine, TXThe loss of airplane control during a precautionary landing resulting in a hard landing.NTSB CEN14LA419Accident · 1 fatalLimited investigationFinal reportEvolution Trikes Revo · South Haven, MIThe noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his loss of aircraft control and the resultant overstress and in-flight breakup of the weight-shift-control aircraft.NTSB ERA14FA377Accident · 2 fatalField investigationFinal reportCessna 150 · Senoia, GAThe noninstrument-rated pilot’s inadequate preflight weather planning and his improper decision to attempt a visual flight rules flight in night instrument metrological conditions, which resulted in subsequent collision with terrain.NTSB CEN14LA424Accident · 2 fatalLimited investigationFinal reportBarger Steve M RV-7A · Russell, IAThe noninstrument-rated pilot’s inadvertent entry into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.NTSB ERA14CA373Accident · Minor injuriesData collectionFinal reportPiper PA-46-350P · Statesville, NCThe pilot's failure to maintain a proper glide path and airspeed on final approach, which resulted in a long landing and runway excursion.NTSB ERA14FA359Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Clayton, GAThe pilot’s decision to begin a flight with fog and low clouds present at the airport, which resulted in an encounter with instrument meteorological conditions immediately after takeoff and a controlled flight into terrain.NTSB CEN14FA369Accident · 3 fatalField investigationFinal reportAgusta A109E · Newkirk, NMThe pilot's inadvertent visual flight into instrument meteorological conditions, which resulted in a loss of helicopter control.NTSB WPR14FA286Accident · 1 fatalField investigationFinal reportCessna 182 · Fall City, WAThe pilot’s decision to depart in low-ceiling conditions and his continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR14FA231Accident · 1 fatalField investigationFinal reportGrumman G 21A · Sula, MTThe pilot's decision to continue flight into deteriorating weather conditions in an airplane not maintained for instrument flight, which resulted in a loss of control due to spatial disorientation.NTSB ERA14FA292Accident · 1 fatalField investigationFinal reportColumbia Aircraft Mfg LC41 550FG · East Patchogue, NYThe noninstrument-rated pilot's encounter with instrument meteorological conditions and his decision to continue visual flight rules flight in instrument conditions, which resulted in a loss of control due to spatial disorientation.NTSB WPR14FA244Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA 5B · Florence, ORThe noninstrument-rated pilot’s visual flight into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.NTSB ERA14FA288Accident · 1 fatalField investigationFinal reportPiper PA-46-500TP · White Plains, NYThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion). Contributing to the accident was the pilot's self-induced pressure to depart and his decision to depart in low-ceiling and…NTSB CEN14FA278Accident · 1 fatalField investigationFinal reportHermann Bjorn Lancair IV · Duluth, MNThe pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…NTSB CEN14FA265Accident · 2 fatalField investigationFinal reportCessna 150 · Watkins, COThe pilot’s loss of control and subsequent aerodynamic stall due to spatial disorientation in night instrument meteorological conditions. Contributing to the accident was the pilot’s distraction due to his cell phone use while maneuvering at low-altitude.NTSB WPR14FA188Accident · 2 fatalField investigationFinal reportMooney M20C · Cody, WYThe non-instrument rated pilots’ decision to continue flight into known instrument meteorological conditions over mountainous terrain, which resulted in controlled flight into terrain.NTSB CEN14FA224Accident · 4 fatalField investigationFinal reportPiper PA 32R-300 · Highmore, SDThe pilot's decision to continue the flight into known deteriorating weather conditions at a low altitude and his subsequent failure to remain clear of an unlit wind turbine. Contributing to the accident was the inoperative obstruction light on the wind…NTSB WPR14FA172Accident · 1 fatalField investigationFinal reportNBB Glasair III · Young, AZThe noninstrument-rated pilot’s decision to enter instrument meteorological conditions, which resulted in the loss of airplane control.NTSB ERA14CA189Accident · No injuriesData collectionFinal reportMoore Thomas O Zenith Stol CH701 · Frostproof, FLThe pilot's failure to maintain directional control during a precautionary landing. Contributing to the accident was the pilot's delayed decision to divert due to deteriorating weather.NTSB WPR14TA149Accident · No injuriesFinal reportBell OH-58A · Tehachapi, CAThe pilot's decision to attempt a mission at night with known en route weather conditions below operating minimums, likely due to self-induced pressure, and then continue flight beyond the alternate landing airport as weather conditions deteriorated, which…NTSB ERA14FA163Accident · 1 fatalField investigationFinal reportDehavilland DHC-1 · Vonore, TNThe pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.NTSB CEN14FA145Accident · 1 fatalField investigationFinal reportBeech B100 · Pearland, TXThe noninstrument-rated pilot's loss of airplane control during a missed instrument approach. Contributing to the accident was the pilot's decision to file an instrument flight rules flight plan and to fly into known instrument meteorological conditions.NTSB CEN14FA141Accident · 3 fatalField investigationFinal reportBeech 35/33 · Telluride, COThe airplane’s failure to obtain a positive climb rate, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB ERA14LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Pinson, TNThe noninstrument-rated pilot’s decision to continue flight into deteriorating weather conditions at night and his failure to divert in a timely manner, which resulted in an off-airport precautionary landing and subsequent substantial damage to the airplane.NTSB ERA14LA117Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Stuart, FLThe noninstrument-rated pilot’s continued flight into dark night, instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation and subsequent impact with water.NTSB CEN14LA129Accident · No injuriesLimited investigationFinal reportCessna 525 · Elk City, OKThe pilot’s descent below the published minimum descent altitude for the instrument approach procedure, which resulted in impact with a utility pole.NTSB CEN14GA135Accident · 1 fatalFinal reportCessna 210E · Oden, ARThe pilot’s improper decision to fly into an area with reported marginal meteorological conditions in an airplane not maintained for instrument flight and his subsequent failure to maintain clearance from trees and terrain.NTSB ERA14FA093Accident · 1 fatalField investigationFinal reportAmerican Champion 8KCAB · Holland, NJThe pilot's continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into trees and terrain.NTSB CEN14CA114Accident · No injuriesData collectionFinal reportCessna 340 · Coldwater, MIAirport personnel did not remove the snow banks from the intersecting runway and/or close the intersection runway, which resulted in the airplane impacting the snow banks. Contributing to the accident was the reduced visibility inhibiting the pilot's ability…NTSB CEN14FA110Accident · 1 fatalField investigationFinal reportCessna 310R · Waterford, MIThe pilot's controlled flight into terrain during an instrument landing system approach at night in instrument flight rules conditions. Contributing to the accident were the operator's inadequate training of the pilot, the operator's failure to provide a…NTSB CEN14FA102Accident · 2 fatalField investigationFinal reportMooney M20R · Boyne City, MIThe pilot’s failure to maintain control of the airplane as he attempted to return to the airport after encountering dark night conditions and heavy snow showers.