NTSB investigations, FL
213 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 15 |
| 1984 | 8 |
| 1985 | 15 |
| 1986 | 17 |
| 1987 | 9 |
| 1988 | 11 |
| 1989 | 11 |
| 1990 | 10 |
| 1991 | 6 |
| 1992 | 6 |
| 1993 | 6 |
| 1994 | 6 |
| 1995 | 13 |
| 1996 | 8 |
| 1997 | 9 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 9 |
| 2004 | 4 |
| 2005 | 7 |
| 2006 | 5 |
| 2007 | 7 |
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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
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\" = 351)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351) 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 MIA08LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Sarasota, FLA loss of engine power due to contamination in the fuel filter.NTSB MIA07LA140Accident · No injuriesLimited investigationFinal reportCessna 208B · Cross City, FLA total loss of engine power during cruise flight due to the fracture and separation of the compressor turbine blades for undetermined reasons. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB NYC07LA183Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Fort Lauderdale, FLThe total loss of power in one engine during approach, due to a fatigue fracture of the crankshaft.NTSB MIA07LA089Accident · Serious injuriesLimited investigationFinal reportHiller UH-12C · Plant City, FLThe loss of engine power due to a magneto impulse coupling failure for undetermined reasons.NTSB MIA07LA085Accident · Minor injuriesLimited investigationFinal reportSmith Carter A Wheeler Exp 2000 · Stuart, FLContamination of the fuel system which resulted in a loss of engine power. Contributing to the accident was unsuitable terrain for a forced landing.NTSB MIA07LA055Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Miami, FLThe pilot-in-command's (CFI) continued operation of the airplane with known deficiencies (rough running engine). A factor in the accident was no suitable terrain for a forced landing.NTSB MIA07LA050Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fountain, FLA loss of engine power due to a cracked engine exhaust muffler. Contributing to the accident were the inadequate inspection procedures of the muffler system and the routing of the "P" leads wiring for the magnetos.NTSB MIA06LA121Accident · No injuriesLimited investigationFinal reportCessna T210 · Crestview, FLSpinning of the crankshaft No. 2 main bearing for undetermined reasons resulting in damage to the aft cheek of the No. 2 main bearing journal and fatigue failure of the crankshaft.NTSB MIA06IA110Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Augustine, FLThe loss of engine power due to separation of the crankshaft as a result of lack of adequate oil lubrication to the #2 main bearing. The lack of oil lubrication was most likely the result of improper assembly (fitting) of the bearing shells to the crankshaft.NTSB MIA06LA067Accident · No injuriesLimited investigationFinal reportCirrus SR20 · Orlando, FLCatastrophic engine failure due to a low oil level brought about by excessive blow-by and cylinder detonation. Contributing factors in this accident were the inadequate instructions contained in Service Bulletin M89-9 and the ditch.NTSB MIA06LA066Accident · Minor injuriesLimited investigationFinal reportLoehle P5151 · Lakeland, FLThe pilot's delay in initiating landing flare during a forced landing following a total loss of engine power. A factor was the lack of correct venting of the carburetor float bowl.NTSB MIA06LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Baker, FLA loss of engine power due to an oil line leak and oil exhaustion. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB MIA06FA024Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Mims, FLThe loss of engine power due to improper installation of the #2 cylinder by maintenance personnel, which resulted in the separation of the cylinder as a result of fatigue cracking of the cylinder to crankcase fasteners. A contributing factor was the lack of…NTSB MIA05LA164Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Arcadia, FLA loss of engine power due to the failure of the master rod bearing.NTSB MIA05TA124Accident · Minor injuriesFinal reportBell OH-58A · St. Augustine, FLThe failure of the compressor section of the engine for undetermined reasons resulting in the total loss of engine power during the initial climb. A factor in the accident was the operator's use of a confined area for takeoff during non-emergency or routine…NTSB ATL05LA103Accident · 1 fatalLimited investigationFinal reportRutherford Seawind 3000 · Sarasota, FLMaintenance personnel failure to secure throttle linkage on the carburetor which resulted in loss of engine power and a collision with a building.NTSB ATL05LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Myers, FLA loss of engine power due to the connecting rod cap separation for undetermined reasons. Related factors were trees and the swampy terrain condition.NTSB MIA05FA123Accident · Serious injuriesField investigationFinal reportDouglas R4D-8 · Fort Lauderdale, FLThe inadequate maintenance inspection by company maintenance personnel/pilot and other maintenance personnel of the left engine resulting in a total failure of the master rod bearing, and nose case partial separation, which prevented the left propeller from…NTSB MIA05LA111Accident · Minor injuriesLimited investigationFinal reportHamilton Stoddard Glassair II S · Palm City, FLImproper maintenance by other maintenance personnel, which resulted in the throttle cable being loose and detaching from the throttle arm during takeoff, resulting in a loss of engine power.NTSB MIA05FA040Accident · No injuriesField investigationFinal reportConvair Div. of Gen. Dynamics 340 · N. Miami Beach, FLThe improper maintenance of the left engine by company maintenance personnel (failure to flush metal from the oil system and failure to properly preserve the engine for storage) resulting in a total failure of the master rod bearing and contamination of the…NTSB MIA04LA099Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Deland, FLA loss of engine power due to an engine master rod bearing failure for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB MIA04LA067Accident · No injuriesLimited investigationFinal reportCessna 206 · Clewiston, FLThe failure of the No. 2 cylinder connecting rod for undetermined reasons, and the failure of one of the connecting rod bolts due to tension overload resulting in the total loss of engine power and subsequent collision with a ditch during the forced landing.NTSB MIA04LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Immokalee, FLA loss of engine power due to the airplane mechanic's improper maintenance/installation and failure to ensure that the B-nut on the inlet side of the fuel manifold was properly tightened, which resulted in a fuel leak, and fuel starvation.NTSB MIA04LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Ocala, FLloss of engine power due to oil starvation for undetermined reasons, resulting in an in-flight collision with a fence during a forced landing.NTSB ATL04TA012Accident · No injuriesFinal reportCessna 210L · Tallahassee, FLLoss of engine power due to crankshaft counterweight failure.NTSB MIA03LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Fort Pierce, FLFailure of one blade in the engine compressor turbine disk due to fatigue which was caused by loss of gap between the blade platforms as a result of corrosion due to a foreign element (phosphate). This resulted in loss of engine power during takeoff and…NTSB MIA03LA160Accident · No injuriesLimited investigationFinal reportCessna T210M · Hialeah, FLSpinning of the crankshaft No. 2 main bearing for undetermined reasons resulting in damage to the aft cheek of the No. 2 main bearing journal, fatigue failure of the crankshaft cheek, failure of the engine in cruise flight, and damage to the airplane during…NTSB MIA03LA139Accident · Serious injuriesLimited investigationFinal reportSamual G. DaSilva Velocity · Sebastian, FLThe improper repair of the crankshaft by a FAA Certified Repair Station resulting in fatigue failure and subsequent total loss of engine power. A factor in the accident was the rough/uneven terrain encountered by the pilot during the landing roll in a field.NTSB MIA03LA123Accident · Minor injuriesLimited investigationFinal reportZenith 601HDS · Immokalee, FLExcessive rotor distributor shaft clearance that resulted in damage to the distributor rotor, a loss of ignition, the engine ceasing to operate. This resulted in a forced landing to unsuitable terrain and the airplane nosing over.NTSB MIA03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Sarasota, FLA loss of engine power due to the crankshaft bolt losing torque, the gear disengaging, and the engine ceasing to operate as a result of inadequate maintenance installation.NTSB MIA03LA080Accident · Serious injuriesLimited investigationFinal reportDitommasso-Keminski Great Lakes 2T-1A · Daytona Beach, FLThe pilot's improper preflight planning/decision to perform a second flight with known deficiencies in equipment, and his failure to maintain airspeed above the airplane's stall speed while maneuvering to reverse direction to land, after the engine…NTSB MIA03LA048Accident · No injuriesLimited investigationFinal reportCessna 172F · Jacksonville, FLa total loss of engine power due to the failure the oil filter because of over-pressurization, resulting in damage to the airplane during the subsequent forced landing.NTSB ATL02FA175Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Milton, FLA sheared mixture cable which resulted in a loss of engine power.NTSB MIA02FA131Accident · 2 fatalField investigationFinal reportAmerican General AA-5 · Boca Raton, FLThe owner/operator's failure to perform an overhaul or comply with a service bulletin 240 which would have probably precluded the continued installation of the number four cylinder exhaust valve and its subsequent failure.NTSB MIA02LA121Accident · Minor injuriesLimited investigationFinal reportKenneth Parmerter Loehle 5151 Mustang · Lake Placid, FLThe pilot's failure to maintain airspeed and his inflight loss of control while maneuvering to land following an engine failure. Contributing to the accident was the builder/owner's improper engine installation that resulted in engine overheating and ceasing…NTSB MIA02FA100Accident · No injuriesField investigationFinal reportBell 206L-1 · Fort Lauderdale, FLThe excessive rate of descent by the pilot-in-command during the autorotative landing resulting in a hard landing, following a total loss of engine power caused by failure of the No. 4 bearing.NTSB ATL02LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, FLTotal loss of engine power due to oil starvation to the No. 3 connecting rod preceded by aft displacement of the center main bearing due to excessive wear. This resulted in a forced landing to none suitable terrain and subsequent on-ground collision with a…NTSB MIA02LA018Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Belle Glade, FLThe loss of engine oil for undetermined reasons that resulted in the engine seizing, a forced landing on a dirt road, and an impact with a vehicle on the dirt road during the landing rollout.NTSB ATL01LA110Accident · No injuriesLimited investigationFinal reportCessna 172R · Orlando, FLThe improper installation of the engine vacuum pump by maintenance personnel which resulted in oil exhaustion and the subsequent loss of engine power. A factor was the none-suitable terrain.NTSB MIA01LA168Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Key West, FLThe improper installation of the cylinders by other maintenance personnel for failure to assure that the cylinders were properly torqued resulting in fatigue crack in the crankshaft, and crankshaft failure. A finding in the investigation was fretting of both…NTSB MIA01LA150Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Fort Pierce, FLThe loss of engine power during takeoff/initial climb due to compressor turbine blade separation.NTSB MIA00IA191Incident · No injuriesIncident investigationFinal reportDassault F2TH Falcon · Fort Lauderdale, FLthe fatigue failure of the rivets used to secure the inner casting forward static seal to the 1st-stage low-pressure turbine support/nozzle assembly. The failure of the rivets allowed the forward static seal to machine a groove into the 2nd-stage…NTSB MIA00TA070Accident · Minor injuriesFinal reportBell UH-1H · Fort Myers, FLA total loss of engine power due to turbine wheel fracture resulting from fatigue for undetermined reasons that resulted in an autorotation to unsuitable terrain and hard touchdown and rollover.NTSB MIA99LA213Accident · No injuriesLimited investigationFinal reportWilliam Jay Kinney Challenger II · Pahokee, FLfailure of the engine to propeller drive belt for undetermined reasons, resulting in loss of engine power, and a forced landing to unsuitable terrain.NTSB ATL99LA109Accident · 1 fatalLimited investigationFinal reportBlackburn John D. Jr. Bushby M II · Daytona Beach, FLThe pilot's failure to securely reconnect the distributor coil wire during routine maintenance. Factors were the unsuitable terrain and trees.NTSB MIA99LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Boca Raton, FLa total loss of engine power due to a failed oil pump impeller which resulted in a forced landing and a subsequent hard landing on a golf course.NTSB MIA99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 210G · Lake Placid, FLa total loss of engine power due to an in-flight separation of the crankshaft, caused by a fatigue crack that originated from the aft fillet radius of the No. 2 main journal, resulting in a forced landing in a field and impact with a tree.NTSB MIA99LA079Accident · Minor injuriesLimited investigationFinal reportWolf Seawind 3000 · Bradenton, FLTotal loss of engine power due to a burned piston for undetermined reasons resulting in a forced landing to unsuitable terrain and the subsequent crash landing onto a golf course.NTSB MIA99LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power due to a connecting rod failure for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB MIA98LA209Accident · No injuriesLimited investigationFinal reportCessna A-188B · Zolfo Springs, FLTotal loss of engine power due to catastrophic internal engine failure caused by migration of a counterweight retaining.