NTSB investigations: Amateur-built UNKNOWN ENG, NJ
15 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
| 1967 | 1 |
|---|---|
| 1973 | 1 |
| 1979 | 1 |
| 1988 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2008 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2017 | 1 |
| 2021 | 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\" = 'NJ' 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" = 'NJ' 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 ERA21LA337Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV7 · Mount Holly, NJThe pilot’s improper recovery from a bounced landing, resulting in a touchdown on the nose gear first, resulting in damage to the nose gear and a runway excursion.NTSB ERA17FA265Accident · 1 fatalField investigationFinal reportNorth Wing Freedom · Green Township, NJThe pilot's improper preflight setup of the aircraft's foldable wing, during which he incorrectly attached a nylon strap loop pull handle, instead of the steel cable shackle at the end of the strap, to its mounting hook. The nylon strap failed in flight,…NTSB ERA12CA533Accident · Minor injuriesData collectionFinal reportStearman M-2 · Robbinsville, NJThe pilot's failure to maintain directional control during the landing roll.NTSB ERA11FA468Accident · 1 fatalField investigationFinal reportMitchell David N Lancair IV P · Hammonton, NJThe Lancair pilot's failure to see and avoid the aerobatic airplane. Contributing to the accident was the Lancair pilot's inadequate use of collision avoidance strategies while inbound to an area of known potential aerobatic activity.NTSB NYC08LA222Accident · 2 fatalLimited investigationFinal reportDennis P. McGurk F1 Rocket · Woodbine, NJA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the proper tank prior to performing aerobatics.NTSB NYC08LA107Accident · Serious injuriesLimited investigationFinal reportChrister Vans RV9-A · Princeton, NJA loss of engine power due to the pilot/owner's improper installation of a new ignition/fuel control system for the engine. Contributing was the unsuitable terrain for a forced landing.NTSB IAD05CA098Accident · No injuriesData collectionFinal reportGrumman G164A · Williamstown, NJThe pilot's misjudgment of distance/altitude, and his failure to maintain obstacle clearance.NTSB NYC02FA138Accident · Serious injuriesField investigationFinal reportYakovlev YAK 52 · Matawan, NJThe pilot's excessive maneuvering and failure to maintain aircraft control, following a partial power loss during the initial climb, which resulted in an inadvertent stall/spin. A factor in the accident was an inadequate annual condition inspection performed…NTSB IAD01LA067Accident · No injuriesLimited investigationFinal reportde Havilland DH-82 Tiger Moth · Allamuchy, NJThe loss of engine power over unsuitable terrain due to an exhaust valve stuck in the open position.NTSB NYC98LA010Accident · No injuriesLimited investigationFinal reportSukhoi SU-29 · Williamstown, NJThe pilot misjudged his altitude and airspeed.NTSB NYC96LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Readington, NJthe pilot's inadequate evaluation of the weather, and his misjudgment of altitude and distance from the runway. Contributing factors were the pilot's lack of recent experience and the weather.NTSB NYC88DHD02Accident · Minor injuriesFinal reportDarlington Monnett Moni · Vincentown, NJThe plt was on his 1st flt in the home built acft. During the initial climb after takeoff, he diverted his attention from the airspeed indicator to other instruments. He believed that he may have inadvertently pulled up the nose at that time. Subsequently,…NTSB NYC79FA076Accident · No injuriesClosedRichard KR-2 · Asbury Park, NJNTSB NYC74FHD08Accident · No injuriesClosedFokker DR-1 · Woodbine, NJNTSB NYC67D0451Accident · No injuriesClosedCessna 310H · Pluckemin, NJ