NTSB investigations: Amateur-built UNKNOWN ENG
2,048 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.\"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."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 NYC82DA178Accident · No injuriesFinal reportPiper PA-28-181 · Dubois, PAAfter power interruption during cruise the pilot returned to the airport for landing. Turning base leg the engine ouit. The pilot cut short the base leg and landed on the grass beside runway 25. No reasons for engine malfunction was found.NTSB CHI82FA260Accident · 1 fatalField investigationFinal reportRotorway Scorpion TOO · Niles, OHThe plt's wife stated that the helicopter was taken across the street to an open field where the plt conducted his flt in the acft. She had never seen him fly this acft over about 3 ft AGL. The helicopter was observed to jump as if lifted by a gust of wind &…NTSB ATL82DA206Accident · No injuriesFinal reportPitts S2S · Somerville, TNShortly after touchdown during a formation landing, the wingman's aircraft struck an engine stand that had been placed over a hole in the runway. The hole was located about 900 ft from the approach end and was about 2 ft long, 1 ft wide, and 1 ft deep. It was…NTSB ATL82DA200Accident · No injuriesFinal reportErcoupe 415-C · Richmond, KYPilot hand propped aircraft which broke tail tie-down rope and taxiied unattended into a runway light and a ditch about 175 feet from starting point.NTSB SEA82DA110Accident · No injuriesFinal reportRockwell Int'T S2R · Adrian, ORThe pilot landed on a dirt strip that had just been bladed. After touching down in a 3-point attitude, the aircraft rolled about 100 ft and then veered to the left. The pilot stated that he could not correct the situation with right brake and rudder, and…NTSB SEA82DA096Accident · No injuriesFinal reportBensen B-8M · Kennewick, WAThe pilot stated that he was demonstrating the gyrocopter's vertical decent capability at an eaa fly-in. He flew the aircraft into the wind at approximately 200 feet, reduced power and failed to recover from the sink rate.NTSB LAX82DAMS1Accident · 2 fatalFinal reportWing D-1 · Catalina Island, CAThe flt departed torrance at 1259 PDT & VFR conditions existed at the time. When the flt did not return a search was initiated. The search was terminated after 4 days. Friends & relatives speculated this may have been a dual instruction flt in preparation for…NTSB FTW82FRD15Accident · Serious injuriesFinal reportGrumman G-164A · Egan, LAAs the plt was adjusting the powerplant & prop controls the eng accelerated, & at the same time oil covered the windshield. The acft went down into a bean field & flipped over. Disassembly of the eng revealed the rear counterweight trailing pin worn &…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 CHI82DA201Accident · No injuriesFinal reportCessna 140 · Stevens Point, WIDuring arrival, the pilot entered traffic for runway 21. The wind was from 180 degrees at 15 gusting to 35 KTS. The pilot stated that while on final approach, he slipped the plane to the right to land on the grass, but went beyond the smooth grass. After…NTSB CHI82DA197Accident · No injuriesFinal reportAdams A55 · Fritchton, INThe pilot decided to land due to deteriorating weather. A descent was initiated but the pilot was waved off by the owner of the property. The pilot regained altitude and landed in a corn field. A gust of wind caused the balloon to drift, the basket was drug…NTSB ATL82DA150Accident · No injuriesFinal reportBell 47D1 · Blountville, TNThe aircraft lost power at 100 feet above ground level. An autorotation was attempted to a highway. The hard landing resulted in the main rotor severing the tail.NTSB CHI82DA147Accident · Serious injuriesFinal reportMong Sport MS-1 · Pendleton, INWhen the pilot arrived at anderson, Indiana, he was unable to find the ace airport. He saw huntzinger airport, a private strip, and decided to land to find out exactly where ace airport was located. During an approach to the sod runway, the aircraft collided…NTSB MIA82DLA05Accident · 1 fatalFinal reportRaz-Mut 440A · Deland, FLThe pilot of this amateur/experimental aircraft was on an initial test flight. During the takeoff roll, the aircraft was observed to swerve left and right just before lift-off. After lift-off, it was observed to climb to about 70 to 100 ft AGL and drift left.…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…NTSB SEA82DA047Accident · No injuriesFinal reportSikorsky S-58J · Siletz, ORAfter lift-off with a 3000 pound external sling load, a "pop" was heard followed by low-level vibration. Rotor RPM decayed and an autorotation was effected to a forced landing in a revine. Postcrash inspection revealed a failure of the engine drive "short…NTSB SEA82DYA06Accident · Serious injuriesFinal reportRotorway Scorpion TOO · Jerome, IDThe pilot was familiarizing himself with the home built helicopter. After hovering in one general area for about 45 minutes, he decided to hover to an open area by crossing a fence. He stated that he entered translational lift at about 20 knots while hovering…NTSB MIA82DA028Accident · No injuriesFinal reportSmith WCS-222 (Bell 47G) · Miami, FLDuring flight, the engine lost power and fire erupted on the engine compartment. Subsequently, the engine driven hydraulic boost for the flight control system became inoperative. The pilot was flying over a populated area. During his forced landing, he was…NTSB DEN82FTE10Accident · No injuriesClosedMome II · Longmont, CONTSB SEA82DYK02Accident · No injuriesClosedPiper PA-24 · Gold Beach, ORNTSB FTW82DPD01Accident · No injuriesClosedPiper PA-36 · Munday, TXNTSB SEA81DYM39Accident · No injuriesClosedGeo. Mccall KR-2 · La Grande, ORNTSB SEA81FYK17Accident · Serious injuriesClosedPiper PA-12 · Bend, ORNTSB CHI81DEC41Accident · Minor injuriesClosedBlanik L-13 · Oxford, MINTSB DEN81FTK16Accident · No injuriesClosedGrum-Amer AA-5B · Custer, SDNTSB DEN81FA053Accident · 2 fatalClosedLet Blanik · Aspen, CONTSB DEN81FA048Accident · 1 fatalClosedRyan Aero ST-A · Eaton, CONTSB FTW81FRA39Accident · No injuriesClosedBoeing A75N1 · Hockley, TXNTSB FTW81FRA30Accident · Minor injuriesClosedHughes 269C · Houston, TXNTSB SEA81FYK08Accident · Minor injuriesClosedPiper PA-22 · Medford, ORNTSB FTW81DRD17Accident · No injuriesClosedGrumman G-164A · Lake Charles, LANTSB FTW81DQA21Accident · Serious injuriesClosedRaven AX-7 · Rio Rancho, NMNTSB FTW81DQD18Accident · No injuriesClosedSchweizer 1-26E · Dell City, TXNTSB SEA81FYK07Accident · Serious injuriesClosedHiller Acft UH-12E · Umpqua, ORNTSB LAX81FUJ35Accident · Serious injuriesClosedBobcat 1 · Phoenix, AZNTSB FTW81FRA16Accident · Serious injuriesClosedHelio Acft H-295 · Liberty, TXNTSB ATL81IA033Incident · No injuriesClosedMitsubishi MU-2B · Norfolk, VANTSB LAX81DXQ03Accident · No injuriesClosedCessna 180 · Truckee, CANTSB LAX81FUG01Accident · Minor injuriesClosedTaylorcraft BL-65 · Corona, CANTSB SEA81FYM01Accident · 1 fatalClosedWalker Mini · Trout Lake, WANTSB FTW80FQA46Accident · Minor injuriesClosedSchweizer SGS126 · Moriarty, NMNTSB ATL81FA099Accident · No injuriesClosedSnow AT302A · Selma, ALNTSB FTW80DPD43Accident · No injuriesClosedPiper PA-36 · Knox City, TXNTSB NYC80DA067Accident · Minor injuriesClosedHiller Acft UH-12C · Meriden, CTNTSB LAX80DUG50Accident · Serious injuriesClosedSchweizer SGS126 · Rabbit Dry Lk, CANTSB CHI80FEV31Accident · No injuriesClosedGrumman 164B · Maroa, ILNTSB SEA80DYA20Accident · No injuriesClosedWeatherly 201B · Mountain Home, IDNTSB DEN80FTM31Accident · No injuriesClosedCessna 182 · Hanksville, UTNTSB CHI80FEI29Accident · No injuriesClosedScorpion H1754R · North Jackson, OHNTSB NYC80FFJ08Accident · Minor injuriesClosedJackson Skyblt · Lakeville, NY