Fatal NTSB investigations, FL
11 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1984 | 2 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1990 | 2 |
| 1995 | 1 |
| 1998 | 1 |
| 2004 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352)
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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352) 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 MIA04FA076Accident · 2 fatalField investigationFinal reportCessna 177RG · Tampa, FLImproper maintenance by other maintenance personnel, and the reinstallation of an unserviced magneto during an engine overhaul, which resulted in the magneto malfunctioning, a loss of engine power, and the airplane being ditched into the water.NTSB MIA98FA200Accident · 1 fatalField investigationFinal reportPiper PA-31-310 · Miami, FLThe pilot's inadequate preflight inspection which led to fuel contamination and subsequent loss of engine power. Also causal was the pilot's failure to maintain single engine flying speed (VMC).NTSB MIA95FA115Accident · 5 fatalField investigationFinal reportPiper PA-28-180 · Quincy, FLAn undetermined fuel system problem that resulted in a fuel leak, an engine compartment fire, and a partial loss of engine power. A factor relating to the accident was: the lack of suitable terrain for a forced landing. An exhaust leak from the fracture of an…NTSB MIA91FA020Accident · 2 fatalField investigationFinal reportAero Commander 680V · Fort Lauderdale, FLThe pilot-in-command's decision to continue takeoff with a known deficiency in the airplane - low power on both engines which resulted from open compressor surge valves. The pilot subsequently failed to maintain airspeed while maneuvering in a turn resulting…NTSB MIA91FA017Accident · 1 fatalField investigationFinal reportCessna 150G · Marathon, FLThe pilot-in-command's failure to maintain airspeed, while attempting to make a forced landing following a partial loss of engine power. Fatigue failure of the center rocker boss on the #3 cylinder was a related factor.NTSB MIA89FA054Accident · 2 fatalField investigationFinal reportCessna 310L · Cedar Key, FLThe evidence indicated that personnel failed to tighten a fuel line at the fuel pressure switch on left engine resulting in fuel line leaking into the engine compartment in flight. An inflight fire burned through a fuel crossfeed fuel line which could not be…NTSB MIA87FA046Accident · 2 fatalField investigationFinal reportHughes 369HS · Zephyrhills, FLA witness stated that she heard the eng on the helicopter quit. She looked out her window and watched the helicopter hit the ground, bounce, hit again, flip over and the tail broke off. The helicopter then burst into flames and exploded. Exam of the eng…NTSB MIA86FA119Accident · 2 fatalField investigationFinal reportBeagle B206-2 · Pedro, FLImmediately after take-off, the left eng seized & the prop stopped due to a connecting rod failure. Witnesses reported that about 200 ft above the ground, the acft rolled to the left and collided with a powerline before crashing to the ground in a near…NTSB MIA86FA033Accident · 1 fatalField investigationFinal reportNorth American T-28A · Lantana, FLThe pilot/mechanic had recently re-installed a rebuilt engine in the aircraft and performed a very short run-up prior to takeoff. Witnesses stated the aircraft engine made popping noises and was belching black smoke during the takeoff roll. The aircraft…NTSB MIA84FA265Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Bryceville, FLFlt departed in instrument meteorological conditions. After departure plt failed to maintain assigned headings several times and had to be corrected by ATC. After 15 mins of flight the plt reported he was having problems with the right engine and would like…NTSB MIA84FA165Accident · 1 fatalField investigationFinal reportConsolidated Aeronautics Lake LA-4 · Fort Myers, FLThe eng was heard 'popping' & misfiring during the takeoff roll. About 1 min later while climbing thru 400-500 ft, the plt reported an eng failure & was cleared to land on any rwy. The acft entered a left turn, stalled & spun into a parking lot. An exam of…