Skip to content

NTSB investigations: Amateur-built UNKNOWN ENG, MA

20 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

Where

Latest cases

Query with SQL

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" = 'MA' 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

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\" = 'MA' 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" = 'MA' 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

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 DCA23LA192IncidentClass 4 · LimitedFinal reportLearjet 60 · Boston, MAThe Hop-a-Jet flight crew taking off without a takeoff clearance which resulted in a conflict with a JetBlue flight that had been cleared to land on an intersecting runway.Feb 27, 2023 · N280LJ · 2 aircraft · No damage NTSB ERA22LA270Accident · Minor injuriesClass 3 · LimitedFinal reportBurrill Steven E A Plane · Middleboro, MAA total loss of engine power for reasons that could not be determined.Jun 11, 2022 · N51324 · Substantial damage NTSB ERA22LA187Accident · No injuriesClass 3 · LimitedFinal reportLancair IV · Leicester, MAA separation of the window from the airframe for undetermined reasons.Apr 10, 2022 · N7KJ · Substantial damage NTSB ERA15LA291Accident · No injuriesLimited investigationFinal reportSontonastaso Mosquito · Winchendon, MAA partial loss of engine power due to a faulty electrical wiring crimp in the engine’s ignition system.Jul 29, 2015 · N285XE · Substantial damage NTSB ERA10LA362Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH-58A+ · Rowley, MAThe failure of the power turbine governor internal driveshaft bearings, resulting in the failure of the governor.Jul 15, 2010 · N802JB · Substantial damage NTSB ERA10LA216Accident · No injuriesLimited investigationFinal reportSmith Richard D JR Revolution Mini 500 · Middleboro, MAA loss of engine coolant, which resulted in a loss of engine power during the pilot’s attempt to cushion a precautionary landing. Contributing to the accident was a disconnected engine coolant hose and the pilot's inadequate preflight inspection.Apr 7, 2010 · N118NR · Substantial damage NTSB NYC06LA224Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · East Bridgewate, MAThe completion center's installation of the incorrect (shorter) release cable, and the ground crewmember's improper movement under the flight path during a bin transfer.Sep 19, 2006 · N802JB · No damage NTSB NYC06LA092Accident · Minor injuriesLimited investigationFinal reportMichaud KR2S · North Andover, MAA partial loss of engine power for undetermined reasons, during the initial climb, which resulted in a forced landing into trees.Apr 11, 2006 · N24065 · Substantial damage NTSB IAD03LA033Accident · Serious injuriesLimited investigationFinal reportRotorway Exec 162F · Westford, MAThe inflight loss of control due to the loss of tail rotor effectiveness.Feb 15, 2003 · N241WC · Substantial damage NTSB NYC02LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · Sterling, MAThe student pilots inadequate compensation for wind conditions which resulted in an off-field landing, and the CFI's improper decision to allow the student to fly solo. Factors related to the accident were the gusting wind conditions, and the students lack of…Jan 1, 2002 · N117BB · Substantial damage NTSB IAD01LA069Accident · Serious injuriesLimited investigationFinal reportBucker Jungmann C.A.S.A. 1.131 · Plymouth, MAThe pilot's failure to maintain altitude during an approach and inadequate visual lookout, which resulted in a collision with a runway sign.Jun 15, 2001 · N131HH · Substantial damage NTSB NYC96LA117Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chatham, MAfailure of the oil pump, which resulted in oil starvation and subsequent failure of the number two and four cylinder connecting rods. Also causal was inadequate maintenance by noncompliance with the airworthiness directive that required replacement of the oil…May 28, 1996 · N19708 · Substantial damage NTSB NYC91LA247Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD-82 · East Boston, MAThe malfunction of an electrical component in the cockpit, which resulted in smoke and the subsequent emergency evacuation of the passengers from the airplane.Sep 28, 1991 · N819NY · Minor damage NTSB NYC90LA124Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Barre, MAThe premature commanded tow release by the towplane pilot over unsuitable terrain.Jun 2, 1990 · N3836H · Substantial damage NTSB NYC86FNA01Accident · No injuriesFinal reportSteen Skybolt UNK · Beverly, MAThe Steen Skybolt modified with a turbo-prop conversion experienced a power loss on takeoff after achieving an altitude of 200-300 ft AGL and made a hard landing on the runway remaining. The landing gear collapsed and aircraft received substantial damage. The…Jun 21, 1986 · N932JF · Substantial damage NTSB NYC85LA116Accident · No injuriesLimited investigationFinal reportCentrair 101A · Barre, MAThe acft encountered windshear during the approach to land and landed in trees. By the time the plt realized his situation it was too late and his wing tip hit a tree top. The acft camp to rest in trees.May 4, 1985 · N4429W · Substantial damage NTSB NYC78FNA29Accident · 1 fatalClosedSchweizer 233A · Plymouth, MAJun 10, 1978 · N17958 · Substantial damage NTSB NYC78FNA28Accident · No injuriesClosedCessna 177B · Plymouth, MAJun 4, 1978 · N19708 · 2 aircraft · Substantial damage NTSB NYC75FNA10Accident · No injuriesClosedChampion 7KCAB · Norfolk, MAAug 11, 1974 · N5063X · Substantial damage NTSB NYC70D0080Accident · No injuriesClosedAeronca 7KCAB · Hopedale, MAJul 31, 1969 · N5063X · Substantial damage