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 ERA09LA498Accident · Serious injuriesLimited investigationFinal reportHahn R-W22 Tiger Moth Rep · Symrna, TNA loss of engine power for undetermined reasons.NTSB ERA09LA477Accident · Serious injuriesLimited investigationFinal reportVollenweider R/Hurst R F Vans RV-9A · Marianna, FLFailure of the propeller speed reduction gearbox for undetermined reasons. Contributing to the accident was the pilot’s decision to disregard the manufacturer's mandate to replace the gearbox, the manufacturer's failure to provide owners with technical…NTSB CEN09LA523Accident · 2 fatalLimited investigationFinal reportFrom Here To There PDQ RV-8 · Tea, SDThe pilot's failure to maintain control of the airplane during recovery from an aerobatic maneuver.NTSB ERA09LA457Accident · Serious injuriesLimited investigationFinal reportTidd Wesley Mini-Max · Hodgdon, METhe pilot's mismanagement of the fuel supply, which resulted in fuel starvation.NTSB ERA09LA455Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CM · St. Elmo, ALA partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain adequate airspeed during the forced landing.NTSB CEN09LA486Accident · No injuriesLimited investigationFinal reportGallagher Junior ACE · Oshkosh, WIThe failure of a weld joint on the right rudder pedal leading to the loss of directional control during landing.NTSB ERA09CA432Accident · Minor injuriesData collectionFinal reportBingham Chuck Rotorway 1 · Atlanta, GAThe pilot's failure to maintain control of the helicopter while hovering in gusting wind conditions.NTSB CEN09CA519Accident · No injuriesData collectionFinal reportCessna 182A · Watertown, SDA loss of engine power due to fuel exhaustion as a result of a fuel tank leak. Contributing to the accident was the reported malfunction of the fuel gauge.NTSB WPR09CA481Accident · No injuriesData collectionFinal reportS.C. Aerostar YAK-52W · Kaunakakai, HIThe pilot's failure to maintain clearance from terrain while in the airport traffic pattern in dark night conditions.NTSB WPR09CA368Accident · Minor injuriesData collectionFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe premature launch signal given by the wing walker.NTSB CEN09CA468Accident · No injuriesData collectionFinal reportCorvus Carone MK 1 · Lee's Summit, MOA loss of engine power for undetermined reasons.NTSB ERA09LA412Accident · 1 fatalLimited investigationFinal reportJames O'Bert Vari-Eze · Columbus, GAThe pilots improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB WPR09LA350Accident · Minor injuriesLimited investigationFinal reportBielawa Rotorway E · Sequim, WAThe failure (disbonding) of a composite main rotor blade for undetermined reasons, leading to an immediate loss of control in flight during hover.NTSB CEN09LA440Accident · 1 fatalLimited investigationFinal reportAntares MA-33 · Centerburg, OHThe pilot's failure to maintain adequate airspeed resulting in an aerodynamic stall.NTSB CEN09CA423Accident · No injuriesData collectionFinal reportLewis Keith O Viggenite · Chesterfield, MOThe loss of engine power for unknown reasons.NTSB WPR09LA336Accident · Minor injuriesLimited investigationFinal reportThomas C. Piper Murphy Rebel · Idaho Falls, IDA total loss of engine power during initial climb due to fuel starvation. The underlying reason for the fuel starvation condition could not be determined.NTSB WPR09CA329Accident · No injuriesData collectionFinal reportNalis Glastar · Arlington, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank prior to takeoff.NTSB ERA09CA381Accident · Serious injuriesData collectionFinal reportThompson David Challenger · Waymart, PAThe pilot's failure to maintain adequate airspeed during approach to land resulting in a stall.NTSB WPR09LA325Accident · 2 fatalLimited investigationFinal reportAero Vodochody L-29 · Tehachapi, CAThe pilot’s failure to maintain clearance from terrain while performing a low altitude maneuver.NTSB CEN09CA391Accident · No injuriesData collectionFinal reportShultz Jeffrey D Sonex · Mena, ARThe total loss of engine power for undetermined reasons.NTSB WPR09LA308Accident · 2 fatalLimited investigationFinal reportMayo RV-6A · Cottonwood, AZThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.NTSB ERA09CA361Accident · No injuriesData collectionFinal reportHummelbird Hummelbird · Sunrise, FLA partial loss of engine power during cruise flight for an undetermined reason.NTSB ERA09LA356Accident · 1 fatalLimited investigationFinal reportChris Mitchell Titan Tornado · Chadbourn, NCThe pilot’s failure to maintain aircraft control during initial climb following a loss of engine power. The reason for the power loss was not determined.NTSB WPR09CA283Accident · Minor injuriesData collectionFinal reportSmith Albert F Challenger TWO · Moses Lake, WAThe student pilot's inadequate compensation for the crosswind condition and failure to maintain lateral roll control of the airplane. Also causal was the flight instructor's failure to effectively communicate his instruction to relinquish the flight controls…NTSB ANC09FA052Accident · 2 fatalField investigationFinal reportHarden RV-7 · Elim, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with terrain.NTSB ERA09LA325Accident · 2 fatalLimited investigationFinal reportSmith Bret B Searey · Knoxville, TNThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and uncontrolled descent.NTSB ERA09LA324Accident · Serious injuriesLimited investigationFinal reportDe Havilland Vampire MK-3 · Rochester, NYA loss of engine power due to oil starvation.NTSB ERA09LA323Accident · 1 fatalLimited investigationFinal reportYork Ronald J Rotorway 162F · Berlin, VTA loss of control in flight for undetermined reasons.NTSB ERA09CA313Accident · Minor injuriesData collectionFinal reportPensinger Zodiac 601 · Greeneville, TNAn encounter with wind shear on initial climb after takeoff.NTSB WPR09LA269Accident · 2 fatalLimited investigationFinal reportStorch Aviation Australia PTY SS-MK4 · Boulder, UTThe pilot's failure to maintain clearance from power lines during low altitude maneuvering.NTSB WPR09LA263Accident · 2 fatalLimited investigationFinal reportLanham Lancair IV · Seligman, AZThe pilot's loss of airplane control during en route descent while operating in known icing conditions.NTSB ERA09LA302Accident · 1 fatalLimited investigationFinal reportHazelwood Michael S RV-8 · Decatur, ALThe RV-8 pilot's failure to maintain adequate clearance from the CJ-6A while maneuvering. This report was modified on September 10, 2010.NTSB CEN09CA290Accident · No injuriesData collectionFinal reportBolton Ricky D Rotorway E · Brookeland, TXThe pilot failed to maintain control while hovering in gusty conditions.NTSB WPR09CA232Accident · Minor injuriesData collectionFinal reportAtkins John RAF 2000 G · South Prairie, WAThe pilot's abrupt maneuver to avoid a collision that resulted in an airspeed reduction and subsequent loss of lift provided by the rotor system. Contributing to the accident was the failure of both pilots to maintain an adequate visual lookout for other…NTSB ERA09FA283Accident · 2 fatalField investigationFinal reportBeech K35 · Lantana, FLA total loss of engine power due to disengagement of the idler gear support pin as a result of improper maintenance.NTSB CEN09CA257Accident · No injuriesData collectionFinal reportEnstrom 280FX · Dacono, COA partial loss of engine power for undetermined reasons.NTSB WPR09CA207Accident · Serious injuriesData collectionFinal reportAerostar International Raven S49A · Tracy, CAThe pilot's failure to maintain clearance from the power lines.NTSB WPR09CA198Accident · Minor injuriesData collectionFinal reportBetter Burn LLC/Startube Div Exec 162F · Chandler, AZThe flight instructor's inadequate supervision of the flight and delay in taking remedial action to prevent the helicopter from touching down while drifting. Contributing to the accident was the design of the skid shoes.NTSB ERA09CA245Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Tampa, FLThe pilot's failure to confirm that the landing gear was retracted prior to the attempted water landing.NTSB ERA09LA233Accident · 1 fatalLimited investigationFinal reportCurtiss Wright P-40N · Mastic Beach, NYThe pilot's failure to maintain adequate airspeed while performing aerobatics at low altitude.NTSB ERA09LA231Accident · 1 fatalLimited investigationFinal reportHoward William C KR-2 · Valdosta, GAAn in-flight fire for undetermined reasons.NTSB ERA09LA221Accident · No injuriesLimited investigationFinal reportT51 T51 · Lake Wales, FLA partial loss of engine power due to the carburetor not being secured to its mounting pad.NTSB ERA09LA198Accident · 1 fatalLimited investigationFinal reportMcNear Explorer Coupe · Okeechobee, FLThe pilot's failure to maintain directional control of the gyrocopter while taxiing for takeoff.NTSB ERA09LA193Accident · 2 fatalLimited investigationFinal reportBurkholder Jimmy C Zodiac 601HD · Live Oak, FLThe pilot's loss of control of the airplane for undetermined reasons.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 ERA09LA184Accident · 1 fatalLimited investigationFinal reportKevin Eldredge Stewart · Ocala, FLA loss of engine power due to contamination and clogging of the fuel system by a post-assembly fuel tank sealant.NTSB WPR09CA095Accident · No injuriesData collectionFinal reportDickson Vans RV-8 · El Monte, CAThe pilot's failure to maintain directional control during landing.NTSB CEN09LA124Accident · Minor injuriesLimited investigationFinal reportLavigna Lancair IV P · Iola, KSThe total loss of engine power for undetermined reasons.NTSB WPR09LA071Accident · Minor injuriesLimited investigationFinal reportPZL PZL-104 35A · Oakland, CAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.NTSB CEN09LA113Accident · No injuriesLimited investigationFinal reportCotton Galen M Helicycle · Houston, TXThe loss of engine power during a hover landing which resulted in a hard landing.