Amateur-built UNKNOWN ENG
NTSB investigations · 2,054
Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.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 CHI83LA001Accident · No injuriesLimited investigationFinal reportBenson Gyrocopter · Mt. Vernon, OHThe gyrocopter pilot stated that he landed the aircraft hard, bounced and then nosed over.NTSB CHI82DA332Accident · No injuriesFinal reportHiller 12B · Detroit, MIThe plt entered the Detroit city arpt area from the west with winds from 280 degrees at 18K gusting to 23K. At 150-175 ft AGL the plt added power in order to reduce his closure rate, traveling southeasterly at the time. The acft then started yawing to the…NTSB MKC82DA158Accident · No injuriesFinal reportFairchild Hiller FH 1100 · Mason City, IADuring a swath run, the engine RPM dropped to flight idle and the helicopter was landed hard in a clear area beside the field. An investigation revealed that a sensing line for the fuel control system had failed. This prevented the engine from operating above…NTSB DEN82DA169Accident · Serious injuriesFinal reportQuicksilver Mxii · Broomfield, COReportedly, the pilot made an intersection takeoff from about midfield on runway 02. He stated that he took off at rotation speed plus 2 KTS. The passenger reported that they reached about 40 ft AGL, then lost lift and begun to settle. As the two-place…NTSB DEN82DA165Accident · No injuriesFinal reportBellanca 7GCBC · Yuma, COThe pilot stated that as he touched down the aircraft porpoised "a couple of times." When the aircraft had slowed to approximately 25-30 mph it ran off the runway into soft dirt and nosed over.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, CA
Back to Amateur-built UNKNOWN ENG