NTSB investigations: Amateur-built UNKNOWN ENG
2,047 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 WPR21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Darby, MTThe pilot’s impact with terrain during a go-around following an attempted precautionary landing due to a low oil pressure indication. The reason for the low oil pressure indication could not be determined based on the available information.NTSB ERA21LA236Accident · Minor injuriesClass 4 · LimitedFinal reportMaxson Phil Zodiac CH601XL · Winder, GAPilot’s inadequate supervision of the pilot rated passenger’s actions, which led to a high descent rate and collision with obstacles.NTSB WPR21FA210Accident · 1 fatalClass 3 · FieldFinal reportMark Coby Early Bird Jenny · Stoneville, NCThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and a loss of control.NTSB WPR21LA178Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Brigham City, UTThe student pilot's unintentional selection of raising the landing gear instead of the flaps during a touch-and-go landing, and the flight instructor's delayed remedial action, which resulted in the landing gear retracting during the landing roll.NTSB ERA21LA192Accident · Serious injuriesClass 3 · LimitedFinal reportMeyeres F L/Meyeres M M Skystar Ktfox Clsc 4 · Mountain Rest, SCA partial loss of engine power due to carburetor icing. Contributing to the accident was the engine’s lack of carburetor heat.NTSB WPR21LA165Accident · No injuriesClass 4 · LimitedFinal reportBryan S Happell TANGO2 · Hayden, IDThe pilot’s failure to control the pitch attitude of the gyroplane during landing, which resulted in a loss of control, runway excursion and collision with terrain.NTSB ERA21LA167Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Vienna, GAThe pilot’s improper decision to attempt a takeoff with a quartering tailwind and his failure to reject the takeoff in a timely manner, which resulted in a runway excursion.NTSB ERA21LA138Accident · Serious injuriesClass 3 · LimitedFinal reportDassault Mirage F1 B · Panama City, FLNose landing gear contact with a raised aircraft arresting system during takeoff, which damaged components of the nose wheel steering system and resulted in an uncommanded left turn and loss of directional control.NTSB WPR21LA094Accident · Minor injuriesClass 3 · LimitedFinal reportRandy Wayne Maloney M1 · Eagle Point, ORA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN21LA092Accident · 1 fatalClass 3 · LimitedFinal reportSonex Tailwheel · Burleson, TXA total loss of engine power due to engine seizure. Contributing to the accident was the pilot decision not to orbit the airport, as originally planned.NTSB WPR21LA155Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · St. George, UTThe pilot’s failure to maintain control of the balloon and a member of the ground crews entanglement with a tether rope, which resulted in a serious injury when they fell to the ground after the balloon unexpectedly ascended.NTSB WPR21LA071Accident · Minor injuriesClass 3 · LimitedFinal reportCo Z Cozy · Compton, CAThe partial loss of engine power due to an improperly installed sparkplug.NTSB CEN21LA074Accident · No injuriesClass 4 · LimitedFinal reportZlin Savage Cub-S · Francis, OKThe pilot’s selection of unsuitable terrain for the landing, which resulted in a nose over when the airplane encountered soft sand during the landing roll.NTSB ERA21LA048Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Milton, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB CEN21LA053Accident · 1 fatalClass 3 · LimitedFinal reportTrick Trikes Stss · Holden, MOThe noncertificated pilot’s failure to maintain aircraft control during takeoff.NTSB ERA21LA027Accident · Minor injuriesClass 4 · LimitedFinal reportMuse Stol CH 750 · Sewanee, TNThe airplane’s encounter with a downdraft during the initial climb, which resulted in an impact with trees.NTSB CEN21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox Classic 4 · New Carlisle, OHThe pilot’s failure to maintain pitch control of the airplane during landing, which caused the airplane to nose over during landing roll. Contributing to the accident was the main landing gear modification which increased the airplane’s tendency to nose over…NTSB ERA20LA324Accident · 1 fatalClass 3 · LimitedFinal reportVans RV 8 · Hilliard, FLA total loss of engine power due to oil starvation.NTSB ERA20CA319Accident · No injuriesClass 4 · Data collectionFinal reportRotorway Exec 162F · Kenansville, FLThe pilot’s failure to maintain control of the helicopter during takeoff.NTSB CEN20LA440Accident · No injuriesClass 3 · LimitedFinal reportSwearingen SA227 · San Antonio, TXThe pilot’s failure to fly a stabilized approach which resulted in a hard landing and loss of control.NTSB CEN20LA360Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · St Louis, MOA total loss of engine power due to improper maintenance of the mixture control cable and attachment hardware, which led to a forced landing into a congested area.NTSB WPR20CA293Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Phoenix, AZThe pilot's improper pitch attitude and landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructors delayed remedial action.NTSB CEN20CA337Accident · Serious injuriesClass 4 · Data collectionFinal reportEvektor Aerotechnik L13 · Frankenmuth, MIThe pilot's failure to stow the speed brake prior to attempting takeoff.NTSB CEN20CA311Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Tractor AT 401 · Burlington, COThe pilot’s failure to maintain clearance from guy-wires during low-altitude agricultural operations.NTSB CEN20CA277Accident · Minor injuriesClass 4 · Data collectionFinal reportKitfox Kitfox Sport · Rand, COThe encounter with the downdrafts during the attempted takeoff, which resulted in decreased airplane's climb performance and subsequent impact with terrain.NTSB CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…NTSB CEN20LA267Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Tornado · Mankato, KSA total loss of engine power for reasons that could not be determined based on available information.NTSB CEN20LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSopwith Type 9400 · Van Alstyne, TXAn inflight loss of aileron control due to movement of a control connector.NTSB WPR20LA201Accident · 1 fatalClass 3 · LimitedFinal reportAvia Stroitel AC-5M · Bend, ORA loss of control just after takeoff for reasons that could not be determined based on the available information.NTSB ANC20CA062Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CCK-1865 · Juneau, AKThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB WPR20LA177Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH601 · Maricopa, AZThe pilot’s loss of situational awareness and descent below pattern altitude during the landing approach, which resulted in collision with terrain at night.NTSB WPR20CA142Accident · No injuriesClass 4 · Data collectionFinal reportN126c CCX-2000 · Heber City, UTThe front seat pilot's failure to maintain directional control during the landing roll, and the rear seat pilot's delayed remedial control inputs that subsequently resulted in a ground loop. Contributing to the accident was a lack of communication by both…NTSB ERA20CA152Accident · No injuriesData collectionFinal reportHolmgren Bearhawk · Ahoskie, NCThe collapse of the right main landing gear during a bounced, crosswind landing.NTSB CEN20LA134Accident · 1 fatalClass 3 · LimitedFinal reportMuse P51D · Mesquite, TXThe pilot’s inadvertent exceedance of the airplane’s critical angle of attack for undetermined reasons, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.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 CEN20CA067Accident · Minor injuriesData collectionFinal reportGlasair 1 · Greenville, TXThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing, and his subsequent loss of airplane control during an attempted go-around.NTSB CEN20CA062Accident · No injuriesData collectionFinal reportBeech 76 · St. Charles, MOThe pilot receiving instruction’s misunderstanding of the flight instructor’s instruction and the pilot's and the instructor’s insufficient use of rudder while adding power to the operating engine, which resulted in the airplane rolling left and the wing…NTSB WPR20LA040Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV 6 · Pima, AZA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA20LA045Accident · Minor injuriesClass 3 · LimitedFinal reportYakovlev YAK 52 · Wrightsville, GAA total loss of engine power due to the failure of the No. 5 cylinder exhaust valve, which resulted in an forced off-airport landing.NTSB CEN20CA033Accident · No injuriesData collectionFinal reportPiper PA18 · Kerrville, TXThe pilot’s loss of airplane control during the landing flare, which resulted in a loss of directional control and ground-loop.NTSB WPR20LA026Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Livermore, CAThe improper installation of the flight control stick, which resulted in separation of the flight control stick from the stick stub assembly and an uncontrolled descent and impact with terrain.NTSB ERA20FA029Accident · 1 fatalClass 3 · FieldFinal reportPavel Tango2 · Cedartown, GAThe pilot's loss of control of the gyroplane for reasons that could not be determined based on available evidence.NTSB WPR20LA014Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 6 · Spanaway, WAA total loss of engine power during the initial climb for reasons that could not be determined.NTSB GAA20CA043Accident · No injuriesData collectionFinal reportZenair Zenith 801 · Knoxville, TNThe pilot's failure to maintain a proper descent rate during the approach and his improper landing flare, which resulted in a hard landing.NTSB ERA20FA013Accident · 1 fatalClass 3 · FieldFinal reportSportine Aviacija LAK17B · Tamaqua, PAThe pilot's exceedance of the glider's critical angle of attack while climbing in thermal lift, which resulted in an aerodynamic stall/spin.NTSB WPR20LA007Accident · Minor injuriesClass 3 · LimitedFinal reportHiller UH 12E · Susanville, CAA partial loss of engine power due to multiple overtemperature events and a hot start event, which resulted in thermally damaged internal components of the engine. Contributing to the accident was the lack of suitable terrain on which to perform the forced…NTSB GAA20CA018Accident · Serious injuriesData collectionFinal reportFoxworthy Rick A Sonex · Langley, WAThe pilot's failure to maintain a proper approach path, which resulted in impact with a tree.NTSB WPR20FA005Accident · 1 fatalClass 3 · FieldFinal reportBede BD5 · Camarillo, CAThe No. 4 connecting rod’s bearing shift and separation of the No. 4 connecting rod, which resulted in a total loss of engine power and subsequent forced landing.NTSB ERA20MA001Accident · 7 fatalClass 2 · MajorFinal reportBoeing B17 · Windsor Locks, CTThe pilot’s failure to properly manage the airplane’s configuration and airspeed after he shut down the No. 4 engine following its partial loss of power during the initial climb. Contributing to the accident was the pilot/maintenance director’s inadequate…NTSB GAA19CA567Accident · No injuriesData collectionFinal reportGeorge W. Felix Mosquito · Kershaw, SCThe pilot's improper cyclic input during takeoff, which resulted in a loss of helicopter control, the skid impacting the ground, and a subsequent dynamic rollover.