NTSB investigations: Amateur-built UNKNOWN ENG, FL
147 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases, newest first
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999'))
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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA09LA221Accident · No injuriesLimited investigationFinal reportT51 T51 · Lake Wales, FLA partial loss of engine power due to the carburetor not being secured to its mounting pad.NTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.NTSB ERA09LA193Accident · 2 fatalLimited investigationFinal reportBurkholder Jimmy C Zodiac 601HD · Live Oak, FLThe pilot's loss of control of the airplane for undetermined reasons.NTSB ERA09LA184Accident · 1 fatalLimited investigationFinal reportKevin Eldredge Stewart · Ocala, FLA loss of engine power due to contamination and clogging of the fuel system by a post-assembly fuel tank sealant.NTSB ERA09CA121Accident · No injuriesData collectionFinal reportLake LA-4-200 · Apopka, FLThe pilot's improper flare.NTSB ERA09CA091Accident · No injuriesData collectionFinal reportKimball Enterprises Pitts Model-12 · Weirdales, FLThe pilot's inadequate compensation for the wind conditions. Contributing to the accident was the crosswind.NTSB ERA09FA080Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · Ft. Lauderdale, FLThe failure of both pilots to see and avoid the other aircraft.NTSB ERA09CA024Accident · Minor injuriesData collectionFinal reportLange Flugzeugbau E1 Antares · Winter Haven, FLThe failure of the pilot of the other airplane to announce his intentions prior to takeoff, resulting in a runway incursion. Contributing to the accident was the limited forward visibility due to the runway slope.NTSB ERA09LA001Accident · Serious injuriesLimited investigationFinal reportBezinque Alisport-Silent · Vero Beach, FLThe failure of the electric fuel boost pump which resulted in a loss of engine power due to fuel starvation.NTSB MIA08LA134Accident · 1 fatalLimited investigationFinal reportDouglas A. Pohl Lancair IV-P · Hollywood, FLA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control which resulted in an aerodynamic stall.NTSB MIA08CA085Accident · No injuriesData collectionFinal reportThomas J. Dorsey Searey · Mount Dora, FLThe pilot's failure to verify the position of the landing gear prior to making a water landing.NTSB MIA08LA048Accident · Serious injuriesLimited investigationFinal reportGrumman G-21A · Marathon, FLThe pilot’s failure to maintain control of the airplane during a water landing.NTSB MIA08CA025Accident · No injuriesData collectionFinal reportMessing Roy Sonex · New Smyrna Beac, FLThe pilot's failure to maintain altitude/clearance while on final approach for landing.NTSB MIA08LA007Accident · No injuriesLimited investigationFinal reportCatchot Angus Kitfox IV · Crescent City, FLThe loss of engine power for undetermine reasons.NTSB MIA07LA158Accident · No injuriesLimited investigationFinal reportFly BY Sea Comp AIR 1 · Rockledge, FLLoss of engine power for undetermined reasons.NTSB MIA07CA138Accident · No injuriesData collectionFinal reportAnthony J. Bencivenga Aventura II · Okeechobee, FLThe pilot's failure to maintain directional control of the airplane during landing, which resulted in the pilot being inadvertently ejected and the airplane's impact with the water during an uncontrolled descent.NTSB MIA07CA061Accident · Minor injuriesData collectionFinal reportBruce E. Hotz Wind Wagon · Leesburg, FLThe failure of the pilot to abort the takeoff after recognizing that the engine rpm was 760 less than desired after becoming airborne, and the inability of the airplane to maintain a positive rate of climb resulting in a controlled descent, and in-flight…NTSB MIA07CA046Accident · Minor injuriesData collectionFinal reportC.W Crane T2 · Bunnell, FLThe pilot's inadvertent encounter with adverse weather that resulted in a descent and an impact with terrain.NTSB MIA06LA028Accident · No injuriesLimited investigationFinal reportMestas Felix R Velocity LWFG-E · Punta Gorda, FLA loss of engine power for undetermined reasons.NTSB MIA06LA006Accident · 1 fatalLimited investigationFinal reportSteven W. Jones KR2 · Venice, FLThe in-flight collision with the water for undetermined reasons.NTSB MIA05CA161Accident · Minor injuriesData collectionFinal reportVans RV-3 · Bell, FLThe pilot's failure to maintain visual lookout during a VFR approach toward the runway resulting in-flight collision with trees. Factors in this accident are no lights for the grass strip runway and attempting to land in low natural light visibility…NTSB MIA05LA122Accident · Serious injuriesLimited investigationFinal reportHighsmith Fergy FII B · Chipley, FLThe seizing of the rear engine cylinder during takeoff-initial climb, which resulted in a collision with power lines and structural damage to the airplane during the forced landing.NTSB MIA05CA074Accident · No injuriesData collectionFinal reportDgflugzeugbau DG-800S · Clermont, FLThe pilots failure to maintain airspeed which resulted in the glider stalling and impact with trees during the uncontrolled descent.NTSB MIA05LA029Accident · Serious injuriesLimited investigationFinal reportJoseph R. Sirgo Aquilla · Eustis, FLThe passenger's control interference, which resulted in a loss of control, and the airplane impacting a hangar during takeoff/initial climb.NTSB MIA05FA017Accident · 1 fatalField investigationFinal reportCessna P206 · Jacksonville, FLThe improper setting of the elevator trim by the pilot-in-command, his failure to follow the checklist related to elevator trim setting, and his failure to maintain VS during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and…NTSB MIA05CA038Accident · No injuriesData collectionFinal reportSteven W. Jones KR2 · Zellwood, FLThe failure of the pilot to maintain directional control during landing resulting in the on-ground collision with a drainage ditch.NTSB MIA04LA111Accident · No injuriesLimited investigationFinal reportRobert J. Labonte Defiant · DeLand, FLThe failure of the pilot to fully extend the nose landing gear resulting in collapse of it during the landing roll. A contributing factor in the accident was the lack of a nose landing gear down and locked indicator.NTSB ATL04LA104Accident · 1 fatalLimited investigationFinal reportSukhoi SU-31 · Fort Lauderdale, FLThe pilot's failure to recover from an intentional spin during an attempted aerobatic maneuver.NTSB MIA04LA058Accident · 1 fatalLimited investigationFinal reportOrtmayer/Parson none · Bunnell, FLThe owner/pilot mechanic's failure to comply with a manufacture notice to replace the rotor blades and hub bar assembly, resulting in a failure of the hub bar to hub bar wing attaching bolt and separation of a main rotor blade.NTSB MIA04LA011Accident · Serious injuriesLimited investigationFinal reportLet NP Kinovice Z37A · Oak Hill, FLThe pilots failure to maintain airspeed while maneuvering to re-enter the pattern resulting in an inadvertent stall and impact with trees and the ground during the subsequent uncontrolled descent.NTSB MIA03LA180Accident · No injuriesLimited investigationFinal reportPiper J5A · Winter Haven, FLThe inadequate preflight of the airplane by the pilot-in-command, which failed to detect water-contaminated fuel, and his failure to maintain airspeed resulting in an inadvertent stall.NTSB MIA03LA138Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Belle Glade, FLThe inability of the pilot to maintain directional control of the airplane following a blown right main landing gear tire during the takeoff roll, resulting in the airplane rolling into soft terrain and subsequent nose over. A factor in the accident was the…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 MIA03LA079Accident · 1 fatalLimited investigationFinal reportTechno Avia SP-95 · Panama City, FLThe pilot's attempted abrupt maneuver at a low altitude resulting in loss of control and collision with terrain before control could be regained.NTSB MIA03FA046Accident · 4 fatalField investigationFinal reportCessna M337B (O-2A) · Fernandina Bch, FLThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent collision with the ocean.NTSB MIA03LA047Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Fort Myers, FLThe pilot's inadequate preflight/preparation and his in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB MIA03LA045Accident · 1 fatalLimited investigationFinal reportBornhofen Twinjet 1500 · Melbourne, FLthe pilot-in-command failed to obtain sufficient altitude to clear obstacles at the approach end of the airport which resulted in an in-flight collision with trees.NTSB ATL03LA033Accident · Minor injuriesLimited investigationFinal reportShaw Atlantica 235FG · Melbourne, FLThe pilot's inadvertent liftoff and his failure to maintain airspeed which resulted in a stall.NTSB MIA02LA139Accident · 1 fatalLimited investigationFinal reportInteravia E-3 · Santa Rosa Bch, FLThe separation of the canopy for undetermined reasons.NTSB MIA02LA136Accident · No injuriesLimited investigationFinal reportYakovlev Yak 52 · Parrish, FLThe in-flight failure of a carburetor/fuel line fitting, resulting in loss of engine power, a forced landing to unsuitable terrain, and a ground collision with a farm vehicle during the emergency landing.NTSB MIA02FA106Accident · Minor injuriesField investigationFinal reportHelicopters & Exec 162F · Tampa, FLThe pilot's intentional operation of the helicopter while impaired by alcohol and a drug (zolpidem) resulting in the in-flight collision with a house.NTSB ATL02LA055Accident · 1 fatalLimited investigationFinal reportKrejci S-51D · Port St. Lucie, FLThe pilots failure to maintain airspeed while maneuvering in an attempt to return to landing area (Emergency/ departure airport.) This resulted in an inadvertent stall and subsequent in-flight collision with terrain. Factor to the accident was a partial loss…NTSB ATL01LA078Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-3 · Titusville, FLThe pilot's failure to maintain directional control during a bounced landing, resulting in a ground loop and subesequent collision with the runway.NTSB ATL01LA030Accident · No injuriesLimited investigationFinal reportLearjet 25B · Ft. Pierce, FLThe mechanic's failure to properly install and secure the left main landing gear aft trunnion pin in accordance with procedures.NTSB MIA00LA234Accident · 1 fatalLimited investigationFinal reportEachon Time Warp Spitfire 9 · Lakeland, FLa loss of control which resulted in an inadvertent stall at too low an altitude to allow recovery. Factors in this accident were, the pilot/owner did not verify that the airplane was balanced before the flight, and he did not perform any weight or balance…NTSB MIA00LA143Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · Lakeland, FLthe pilot's improper inflight planning/decision to land long, with a tailwind, on a wet grass runway that resulted in the loss of control and the airplane exiting the runway, incurring substantial damage.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 MIA99FA108Accident · 1 fatalField investigationFinal reportPushkar Hornet · Fort Lauderdale, FLthe pilot's (owner/builder) inadvertent aerodynamic stall of the airplane after a total loss of engine power. Factors were the pilot's improper maintenance action and his lack of total experience in the airplane type.NTSB MIA99FA043Accident · 3 fatalField investigationFinal reportCessna 402B · Pahokee, FLThe pilot's failure to maintain adequate altitude during the approach.NTSB MIA99LA015Accident · No injuriesLimited investigationFinal reportPeters Strojnik S2A · Pensacola, FLThe aircraft's uncontrolled climb after encountering a wind gust or thermal during landing flare without engine power resulting in the pilot having to force the aircraft onto the runway making a hard landing prior to the end of the runway.