NTSB investigations: Amateur-built UNKNOWN ENG, MD
14 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 per year
| 1964 | 1 |
|---|---|
| 1977 | 1 |
| 1983 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2013 | 1 |
| 2020 | 1 |
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\" = 'MD' 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" = 'MD' 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 ERA20CA107Accident · No injuriesData collectionFinal reportOrlican L60 · Frederick, MDThe pilot's failure to maintain airplane control during the approach, which resulted in the airplane ballooning and then veering left upon landing and the right wing impacting the runway.NTSB ERA13FA309Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Ocean City, MDThe pilot's failure to terminate the intentional aerobatic spin at an altitude adequate to prevent impacting the water. Contributing to the accident was the pilot's loss of situational awareness due to target fixation during the prolonged aerobatic maneuver.NTSB ERA09LA187Accident · Minor injuriesLimited investigationFinal reportDoyle-Michael Sonerai-II · Leonardtown, MDThe pilot's continued operation of the airplane with a known mechanical deficiency. Contributing to the accident was the improper installation of the electronic ignition system.NTSB NYC08CA093Accident · No injuriesData collectionFinal reportJames Dayton Pit Bull JD-3 · Leonardtown, MDThe pilot's improper flare during the landing.NTSB NYC07LA022Accident · 1 fatalLimited investigationFinal reportMonard RAF 2000 GTX · Ridgely, MDThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.NTSB NYC05LA121Accident · 1 fatalLimited investigationFinal reportRatliff Hummel Bird · Pittsville, MDA loss of control for undetermined reasons, which resulted in an uncontrolled descent into terrain.NTSB NYC01FA158Accident · 1 fatalField investigationFinal reportMoravan Zlin 526F · Queen Anne, MDThe pilot's failure to maintain airspeed during an aerobatic maneuver, which resulted in an inadvertent inverted spin.NTSB NYC00LA198Accident · Serious injuriesLimited investigationFinal reportWarrington Surrel Guppy · Churchville, MDThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were an open canopy and a decrease in engine power.NTSB IAD99LA047Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Ocean City, MDWas the pilot leaving the magneto switch in the on position while hand rotating the propeller.NTSB IAD98FA049Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Stevensville, MDThe pilot's abrupt, low-g maneuver, which resulted in mast bumping and separation of the main rotor system.NTSB IAD97LA121Accident · Minor injuriesLimited investigationFinal reportPohlman/Pohlman Rotorway Exec 90 · Westminster, MDThe loss of power due to carburetor icing. A factor to this accident was the carburetor heat was not accessible from within the cockpit.NTSB ATL84LA046Accident · No injuriesLimited investigationFinal reportBell 47-G · Middle River, MDWhile practicing hovering about 2 ft AGL the student allowed the helicoper to start drifting aft & right. The right skid heel contacted the ground & the helicopter roll onto its right side.NTSB IAD77FIA23Accident · Serious injuriesClosedChampion 7ACA · Brandywine, MDNTSB UNK64X2725Accident · Minor injuriesClosedCessna 120 · Laytonsville, MD