NTSB investigations, FL
33 cases where NTSB found Ceiling/visibility/precip.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 6 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2025 | 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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' 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 ERA25FA119Accident · 1 fatalClass 3 · FieldFinal reportCessna 208 · Pierson, FLThe non-instrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB ERA24FA036Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Micanopy, FLThe non-instrument-rated pilot’s improper inflight decision making and his flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident were the pilot’s…NTSB ERA22LA180Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 269A · Fort White, FLThe non-instrument-rated pilot’s decision to fly a visual flight rules only helicopter in instrument meteorological conditions, which resulted in a collision with trees and terrain.NTSB ERA22FA149Accident · 2 fatalClass 3 · FieldFinal reportCessna 182Q · Panama City, FLThe pilot’s deviation from the final approach course during a night instrument approach with low instrument meterological conditions, which resulted in an impact with heavily wooded terrain. Contributing to the accident was the pilot’s decision to continue…NTSB ERA22FA098Accident · 4 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Bronson, FLA loss of control due to spatial disorientation as a result of the noninstrument-rated pilot’s improper decision to attempt a visual flight rules flight at night into an area of known reduced visibility due to fog.NTSB ERA21LA077Accident · No injuriesClass 3 · LimitedFinal reportEmbraer EMB-500 · Jacksonville, FLThe flight crew’s failure to apply maximum braking immediately upon touchdown, which resulted in a runway excursion. Contributing to the accident were 1) the slightly excessive approach airspeed and 2) the flight crew’s decision to land on a wet runway during…NTSB DCA19MA143Accident · Minor injuriesClass 2 · MajorFinal reportBoeing 737 · Jacksonville, FLAn extreme loss of braking friction due to heavy rain and the water depth on the ungrooved runway, which resulted in viscous hydroplaning. Contributing to the accident was the operator’s inadequate guidance for evaluating runway braking conditions and…NTSB ERA19FA116Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Fellsmere, FLThe student pilot's loss of control due to spatial disorientation following an encounter with instrument meteorological conditions shortly after takeoff. Contributing to the accident was the failure of both the pilot and the flight school to ensure that the…NTSB CEN18FA358Accident · 4 fatalField investigationFinal reportBeech B60 · Fort Walton Beach, FLThe pilot's controlled flight into terrain after misidentifying the destination airport during a period of restricted visibility due to weather.NTSB WPR18LA135Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 152 · Tamiami, FLThe non-instrument-rated pilot’s loss of control during an encounter with instrument meteorological conditions at night. Contributing to the accident was the pilot's decision to depart on the flight without obtaining approval to fly at night in accordance…NTSB CEN18FA061Accident · 5 fatalField investigationFinal reportCessna 340 · Bartow, FLThe pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.NTSB ERA18FA056Accident · 1 fatalField investigationFinal reportBeech G35 · Cross City, FLThe pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in the pilot experiencing spatial disorientation and a subsequent loss of airplane control.NTSB WPR18FA045Accident · 3 fatalField investigationFinal reportBeech C90 · Geneva, FLThe pilot's loss of airplane control due to spatial disorientation during an instrument approach in instrument meteorological conditions, and the flight instructor's delayed remedial action. Contributing to the accident was the flight instructor's impairment…NTSB ERA18FA030Accident · 1 fatalField investigationFinal reportMooney M20C · Starke, FLThe pilot's loss of control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing was the pilot's lack of instrument currency and his self-induced pressure to complete the flight.NTSB ERA17LA113Accident · Serious injuriesLimited investigationFinal reportCirrus SR20 · Daytona Beach, FLThe pilot's inadvertent encounter with instrument meteorological conditions (fog) during initial climb, which resulted in a loss of control due to spatial disorientation.NTSB ERA17FA108Accident · 3 fatalField investigationFinal reportPiper PA28R · Cedar Key, FLThe non-instrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.NTSB ERA17FA074Accident · 2 fatalField investigationFinal reportIndependent Technologies Epic LT · Port Orange, FLThe pilot's loss of airplane control due to spatial disorientation, which resulted in the exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's failure to fly a stabilized approach…NTSB ERA16FA074Accident · 2 fatalField investigationFinal reportHinton Paul M RV 4 · Greenville, FLThe pilot's decision to initiate the flight into known adverse weather conditions, in an airplane that was not approved for instrument flight, which resulted in an encounter with instrument meteorological conditions and his subsequent spatial disorientation…NTSB ERA15FA361Accident · 1 fatalField investigationFinal reportCessna U206 · Spring Hill, FLThe pilot's failure to maintain a stabilized instrument approach, which resulted in a loss of control.NTSB ERA15LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Masscotte, FLThe pilot's failure to use carburetor heat during the flight while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's decision to take off…NTSB ERA15FA099Accident · 1 fatalField investigationFinal reportCessna 152 · New Smyrna Beach, FLThe pilot's failure to maintain control of the airplane while operating under visual flight rules (VFR) in night, instrument meteorological conditions, likely due to spatial disorientation. Contributing to the outcome was the radar controller's failure to…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 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 ERA13FA275Accident · 1 fatalField investigationFinal reportCessna 340A · Boynton Beach, FLThe pilot’s loss of situational awareness, which resulted in an inadvertent aerodynamic stall/spin after he climbed the airplane back into instrument meteorological conditions (IMC). Contributing to the accident was the pilot’s improper decision to continue…NTSB ERA13FA144Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Lutz, FLThe noninstrument-rated pilot’s decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in spatial disorientation and a loss of aircraft control. Contributing to the accident was the pilot’s lack of instrument…NTSB ERA13FA105Accident · 3 fatalField investigationFinal reportBeech H35 · Palm Coast, FLA total loss of engine power after the failure of the No. 4 connecting rod due to oil starvation, which resulted in a subsequent forced landing. Contributing to the accident was the pilot’s failure to clearly state that the aircraft had lost all power and the…NTSB ERA12FA151Accident · 1 fatalField investigationFinal reportCessna 150G · Quincy, FLThe non-instrument-rated pilot’s spatial disorientation in night instrument meteorological conditions, which resulted in his inability to maintain controlled flight. Contributing to the accident was the pilot’s improper decision to take off in deteriorating…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 ERA10FA091Accident · 4 fatalField investigationFinal reportCessna 172S · Kissimmee, FLThe pilot's decision to depart under special VFR flight at night when instrument meteorological conditions prevailed at the departure airport and along the route of flight and his continued VFR flight into instrument meteorological conditions, which resulted…NTSB ERA09LA398Accident · 2 fatalLimited investigationFinal reportBarber John A Glasair · Switzerland, FLA loss of control in flight for undetermined reasons. Contributing to the accident was the pilot's performance of aerobatic maneuvers at altitudes lower than those recommended by the kit manufacturer, resulting in insufficient terrain clearance to conduct a…NTSB ERA09FA039Accident · 3 fatalField investigationFinal reportPartenavia P.68C · Gainesville, FLThe pilot's failure to maintain the proper glidepath during an instrument-landing-system (ILS) approach. Contributing to the accident were the pilot's decision to initiate the ILS approach with weather below the published minimums, and the pilot's…NTSB MIA08FA080Accident · 2 fatalField investigationFinal reportCessna 182B · Wildwood, FLThe noninstrument rated pilot's failure to maintain terrain clearance at night in marginal visual flight conditions. Contributing to the accident was the dark night, and low cloud ceilings.NTSB NYC08CA092Accident · Minor injuriesData collectionFinal reportKral Series 5 Kitfox · Fruitland Park, FLThe pilot's failure to maintain adequate clearance from obstructions during the landing approach. Contributing to the accident was the reduced visibility due to sunglare and haze.