NTSB investigations: Amateur-built UNKNOWN ENG
73 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 ANC90LA135Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA-315B · Tok, AKImproper installation of the fuel filter element in the aircraft by company/maintenance personnel, and subsequent contamination of the fuel system by unfiltered fuel. Factors related to the accident were: inadequate design of the fuel filter assembly, which…NTSB CHI90DER04Accident · Minor injuriesFinal reportBD 4- Francisco BD-4 · Rosemount, MNFailure of the manufacturer (amateur built) to design fuel system adequately to prevent vapor lock in fuel line.NTSB LAX90LA142Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Chico, CAFuel starvation due to unporting of the fuel pick up in the fuel tank selected for the takeoff.NTSB MKC89LA065Accident · No injuriesLimited investigationFinal reportComposite Aircraft Mfg Cozy · Hudson, IAImproper preflight by the pilot which resulted in an inadequate fuel supply and fuel exhaustion.NTSB ATL88LA180Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Avon, OHThe acft was on initial climb out when the eng quit. The acft was at an estimated altitude of 100 ft and over trees at the time of the power loss. The plt attempted to return to the airstrip. The acft landed hard in a nose down position off to the side of the…NTSB SEA87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Mount Vernon, WAThe aircraft's engine ceased operating due to fuel exhaustion about five miles short of the destination airport. A field was selected for the landing site. During the landing roll, the aircraft nosed over on freshly plowed terrain.NTSB MIA87FA234Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe student plt was on an aprx 380 mi solo x-country flt fm Vero Beach (vrb) to naples (apf), brooksville (bkv) & back to vrb. He thought he had plenty of fuel for the flt & elected to dep w/o taking a credit card (for fuel). When he lndd at apf & bkv, he did…NTSB DEN87LA097Accident · Minor injuriesLimited investigationFinal reportMclachlan Moni · Tooele, UTThe private plt was cruising the local area near his home in his homebuilt experimental moni. The newly installed engine began to run rough. This engine is not a traditional acft engine and was a two cycle, two cylinder engine manufactured in italy, with an…NTSB MIA87FA118Accident · 1 fatalField investigationFinal reportAero Mirage TC-2 · Williston, FLWitnesses stated that the acft made a 'fly by' at 300 ft to check and see if the gear was down. The ground personnel informed the plt that the gear appeared to be down. They stated that the acft then made a sharp left turn paralleling runway 14, they lost…NTSB ATL86FA266Accident · 1 fatalField investigationFinal reportPiper TG8-J3C-65 · Apex, NCThe plt was practicing takeoffs and landings in his newly acquired J3 at a private airstrip when the eng sputtered and then quit. The plt lost control of the acft and hit a 't' hanger prior to hitting the ground. The acft caught fire and was destroyed,…NTSB NYC86LA160Accident · No injuriesLimited investigationFinal reportHiller 12C · Lehighton, PAThe pilot of the Hiller 12C reported an overheated engine followed by an engine failure. During the forced landing the main rotor flexed and cut the tail boom off the the aircraft. The aircraft was examined. 10 oz. Of a liquid was found in the fuel system. 7…NTSB MIA86FA126Accident · Serious injuriesField investigationFinal reportBlythe Quickie · Eustis, FLThe student pilot departed on a student cross-country flight with 2 gallons of fuel in the tank of the homebuilt quickie. About 30 to 45 minutes later the engine failed at 1800 ft MSL. The student attempted to stretch the glide to a road and struck trees and…NTSB MIA86FA115Accident · 1 fatalField investigationFinal reportPitts Special · Homestead, FLThe plt was on a flt to practice aerobatic mnvrs in a designated practice area. A witness, who was driving nearby, stated that he saw the acft 'falling straight down' & crash in a tomato field. An investigation revealed evidence that the acft had impacted in…NTSB MIA85LA214Accident · No injuriesLimited investigationFinal reportBell 47D1 · Moultrie, GAThe plt stated that while he was on an aerial application mission, the helicopter ran out of fuel. During an autorotation, the main rotor severed the tail boom.NTSB CHI84LA272Accident · Minor injuriesLimited investigationFinal reportHoward E. Lee Rutan Long EZ · Minneapolis, MNThe plt claimed a loss of power during takeoff. He turned and attempted a landing on the arpt. The rwy was overrun and the acft stopped in a wheat field. Post accident examination of the engine revealed no discrepancies.NTSB DCA84AA014Accident · Serious injuriesFinal reportFokker F27-100 · Jamaica, NYDuring the previous flt, the acft encountered light icing conditions while crusing at 4000 ft. the capt stated that the ice disappeared from the acft's structure in the course of its descent at 3000 ft & he did not use wing de-icing or the eng cowling…NTSB NYC84FHM03Accident · No injuriesFinal reportHomebuilt Spad Xiii · Montgomery, NYThe acft lost power about 1 mile from the arpt and the plt made a forced landing on a farm. The acft nosed over. The weather conditions were conducive to carburetor icing and this acft has no provision for carburetor heat control.NTSB DEN83FA131Accident · 2 fatalField investigationFinal reportAero Commander 680FL · Monticello, UTThe acft crashed while doing magnetometer surveys at low altitude. The right engine had lost power then regained it for a short period and lost it again. A videotape in the acft recorded the plt saying, 'I changed that # just in time.' The acft yawed and the…NTSB CHI83LA062Accident · 1 fatalLimited investigationFinal reportScorpion Too · Sandwich, ILThe rotorcraft impacted the runway very hard with no flare after the engine quit 100-200 feet AGL. The pilot had no training in this aircraft. No fuel was found in the fuel tank and no fuel odors were present. An examination of the fuelsystem, engine and…NTSB ATL83LA061Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nashville, TNDuring an autorotation at about 125 ft AGL the student attempted to apply power for a recovery but noted that the oil pressure light was illuminated & the eng had quit. The CFI took the controls & executed an emergency landing. He maneuvered to avoid power…NTSB DEN83LTI01Accident · No injuriesFinal reportScorpion 133 · Manhattan, MTBattery failed because it had not been charged. No on board charging provision. Electric pump could not operate without electricity. No fuel to engine. During an autorotative landing, the tail rotor was damaged. With no tail rotor control, the helicopter slid…NTSB SEA82FYM18Accident · 2 fatalFinal reportMccall KR-2 · Union, ORReportedly, the aircraft departed la grande, OR with 12 gallons of fuel on board and was flown to baker, OR. Later, the pilot departed baker on a return flight to la grande without refueling. Subsequently, the plane was reported as missing. The next day it…NTSB FTW82DA129Accident · No injuriesFinal reportQuickie · Cleveland, TXAfter taking off with full power, the pilot turned left to a crosswind position. Shortly thereafter, he noticed a partial power loss and turned further left to a downwind. From this position, there was a powerline between him and the runway. He elected to…