NTSB investigations, 2000, FL
18 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 24 |
|---|---|
| 1983 | 12 |
| 1984 | 10 |
| 1985 | 14 |
| 1986 | 15 |
| 1987 | 15 |
| 1988 | 12 |
| 1989 | 7 |
| 1990 | 11 |
| 1991 | 20 |
| 1992 | 9 |
| 1993 | 18 |
| 1994 | 13 |
| 1995 | 7 |
| 1996 | 19 |
| 1997 | 21 |
| 1998 | 26 |
| 1999 | 22 |
| 2000 | 18 |
| 2001 | 18 |
| 2002 | 14 |
| 2003 | 8 |
| 2004 | 18 |
| 2005 | 18 |
| 2006 | 14 |
| 2007 | 15 |
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\") = 2000
AND 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\" = 350)
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") = 2000 AND 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" = 350) 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 MIA01LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Fort Pierce, FLThe pilot's improper approach for landing while making a landing following a reported momentary partial loss of engine power for undetermined reasons and his decision to make a go-around from the approach resulting in a landing in a field and collapse of the…NTSB ATL01LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Plant City, FLThe loss of engine power due to fuel starvation resulting from the separation of the mixture control cable from the carburetor. Factors were cows, rough and uneven terrain.NTSB ATL01LA011Accident · No injuriesLimited investigationFinal reportMooney M20E · Fort Myers, FLFuel system contamination that resulted in fuel starvation.NTSB MIA01LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Wewahitchka, FLa loss of engine power due to the number 5 cylinder connecting rod separating at the rod cap, resulting in a forced landing and subsequent impact with rough uneven terrain.NTSB MIA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Zolfo Springs, FLThe loss of engine power for undetermined reasons, which resulted in the pilot executing a forced landing to an open field, and the aircraft subsequently impacting a tree during the landing rollout.NTSB MIA01FA004Accident · 2 fatalField investigationFinal reportRobinson R-22 · Pembroke Pines, FLThe pilot's failure to maintain rotor rpm and the proper rate of descent during a forced landing/autorotation resulting in an in-flight collision with terrain. Contributing to the accident was a loss of engine power due to the failure of the No. 3 exhaust…NTSB ATL00LA088Accident · No injuriesLimited investigationFinal reportCessna 188 · Tampa, FLThe failure of the number six-piston connecting rod that resulted in the total loss of engine power.NTSB MIA00LA251Accident · Minor injuriesLimited investigationFinal reportRyan Navion A · Daytona Bch Sh, FLa loss of engine power due to undetermined reasons, that resulted in the aircraft being ditched.NTSB ATL00LA084Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Vero Beach, FLThe pilot's inability to control the aircraft after landing due to a loss of engine power and landing gear failure for undetermined reasons. A factor in the severity of the accident was the impact with the airport marker lights.NTSB MIA00LA238Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe flight instructor's failure to identify a partial loss of engine power during takeoff roll, and his failure to maintain airspeed while attempting to return to the airport after takeoff resulting in the airplane stalling and descending uncontrolled until…NTSB MIA00LA213Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belleview, FLthe loss of engine power during takeoff/initial climb due to undetermined reasons.NTSB MIA00LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Winter Haven, FLthe flight instructor's failure to follow procedures/directives and his misjudgment of distance/altitude following a loss of engine power for undetermined reasons, which resulted in the proper touchdown point not being attained, an off airport landing being…NTSB MIA00LA158Accident · No injuriesLimited investigationFinal reportPiper J-3 · Boca Raton, FLa loss of engine power due to undetermined reasons that resulted in a forced landing and substantial damage to the aircraft.NTSB MIA00LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fernandina Bch, FLThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall., in-flight collision with terrain, and subsequent nose over.NTSB ATL00LA039Accident · Serious injuriesLimited investigationFinal reportAlon A-2A · Hernando, FLLoss of power due to carburetor contamination. Factors, were the trees, and the weather conditions were conducive to carburetor icing.NTSB ATL00LA033Accident · Serious injuriesLimited investigationFinal reportAero Comp COMP-AIR-6 · Indiantown, FLThe maintenance personnel inadequate inspection of the fuel system that resulted in loss of engine power due to fuel filter contamination.NTSB MIA00LA099Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Brooksville, FLTotal loss of engine power for undetermined reasons on appr oach for landing resulting in an in-flight collision with a dirt bank, separation of the main landing gear, and subsequent nose over. Contributing to the accident was carburetor icing conditions.NTSB MIA00LA094Accident · No injuriesLimited investigationFinal reportNorth American NA-64 · Clearwater, FLA total loss of engine power due to fuel starvation for und etermined reasons. This resulted in a forced landing to none suitable terrain, and a subsequent in-flight collision with trees and terrain.