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 WPR23LA361Accident · Minor injuriesClass 4 · LimitedFinal reportGleim James M MG-1 · Madera, CAAn emergency landing on uneven terrain that resulted in the loss of directional control during landing.NTSB WPR23LA352Accident · Serious injuriesClass 3 · LimitedFinal reportWayne Toddun Sling 4 TSI · San Pedro, CAA total loss of engine power due to a failure of the No. 4 cylinder exhaust valve from overheating and excessive wear.NTSB ANC23LA078Accident · No injuriesClass 3 · LimitedFinal reportRhodes Steven D SR3500 · Nenana, AKA total loss of engine power due to fuel starvation. Contributing was the owner/builder’s inadequate maintenance.NTSB CEN23FA410Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Dowagiac, MIThe total loss of engine power due to the failure of the ignition distributor rotor.NTSB CEN23LA405Accident · No injuriesClass 3 · LimitedFinal reportAlisport Silent 2 Electro · Giddings, TXThe glider’s encounter with flutter during cruise flight that resulted in structural damage to the fuselage.NTSB ERA23LA365Accident · Minor injuriesClass 3 · LimitedFinal reportSheehan Kevin A Vans RV-8 · Umatilla, FLA total loss of engine power for reasons that could not be determined.NTSB WPR23LA330Accident · No injuriesClass 4 · LimitedFinal reportYamaha Fazer SAR · Reno, NVThe operator’s incorrect input into the ground station controller, resulting in a loss of control during flight and subsequent impact with terrain.NTSB ERA23LA351Accident · Serious injuriesClass 3 · LimitedFinal reportNanchang China CJ-6A · Merrickville, NYA total loss of engine power while enroute for reasons that could not be determined.NTSB CEN23FA361Accident · Serious injuriesClass 3 · FieldFinal reportMikoyan Gurevich MIG-23UB · Belleville, MIA reported partial loss of engine power while maneuvering for reasons that could not be determined.NTSB WPR23LA314Accident · Serious injuriesClass 3 · LimitedFinal reportReynolds Ronald B Team Acft Z-MAX · Rigby, IDThe loss of engine power during takeoff due to inadequately secured wires, which resulted in the wearing of the wires’ sheaths and the grounding of the airplane’s electrical system. Contributing to the accident was the pilot’s failure to maintain airplane…NTSB DCA23LA397Accident · No injuriesClass 4 · LimitedFinal reportSupernal SUP83-1 · California City, CAA loss of control in flight due to a loss of electrical power to one of the lift-motors.NTSB WPR23LA292Accident · No injuriesClass 4 · LimitedFinal reportJohn Espe Cruiser · Buhl, IDThe pilot's failure to maintain airplane control during landing with a gusting tail wind.NTSB CEN23LA319Accident · No injuriesClass 3 · LimitedFinal reportAlisport Silent 2 Electro · Wallis, TXThe failure of the tail boom structure due to cyclic torsion overloading as of a result of flutter in the empennage. The reason for the flutter could not be determined.NTSB CEN23LA327Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV10 · Chouteau, OKThe total loss of engine power as a result of a failed positive crankcase ventilation (PCV) valve and a subsequent impact with terrain.NTSB ERA23LA278Accident · No injuriesClass 4 · LimitedFinal reportGopalan Hariharan 4 Place · Sanford, NCThe pilot’s failure to maintain directional control while landing in a crosswind, which resulted in a nose over.NTSB CEN23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportTipton Kitfox Kitfox IV · Odessa, MOThe pilot’s failure to attain the proper touchdown speed, which resulted in a runway excursion and subsequent nose over.NTSB CEN23FA220Accident · 1 fatalClass 3 · FieldFinal reportVans RV7 · Gibbon, NEThe pilot’s improper decision to fly the airplane into known adverse weather and icing conditions which resulted in a loss of control.NTSB CEN23LA197Accident · No injuriesClass 4 · LimitedFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Gueydan, LAThe failure of both pilots to see and avoid each other resulting in a collision on the airstrip. Contributing was the pilots’ failure to announce their intentions over their radios as they were taking off and landing.NTSB ERA23LA241Accident · Minor injuriesClass 3 · LimitedFinal reportBurril Benjamin D BDB001 · Wadesboro, NCA reported total loss of engine power and a subsequent forced landing for reasons that could not be determined because the pilot did not make the wreckage available for examination.NTSB WPR23LA179Accident · No injuriesClass 4 · LimitedFinal reportELY John M Vans Acft RV-8 · North Las Vegas, NVThe pilot’s failure to maintain directional control during landing in gusting wind conditions, which resulted in a ground loop.NTSB WPR23LA354Accident · No injuriesClass 4 · LimitedFinal reportKerr John Hatz Classic · Ennis, MTThe pilot’s failure to maintain directional control during the landing roll which resulted in a ground-loop.NTSB ERA23LA208Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6 · Eaton, OHThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR23FA153Accident · 2 fatalClass 3 · FieldFinal reportMullins David J JR Glastar · Cal-Nev-Ari, NVThe pilot's failure to maintain sufficient altitude for undetermined reasons while maneuvering to land in dark night conditions, which resulted in collision with terrain.NTSB CEN23LA152Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Goldsby, OKThe engine electronic ignition system became disconnected, which resulted in a partial loss of engine power.NTSB WPR23LA132Accident · No injuriesClass 4 · LimitedFinal reportFay David Velocity Elite · Bullhead City, AZThe student pilot’s improper landing during crosswind conditions and the flight instructor’s failure to take remedial action, which resulted in a loss of control.NTSB CEN23LA135Accident · No injuriesClass 3 · LimitedFinal reportBell Helicopter Textron APT70 · Mineral Wells, TXThe flight crew’s loss of control of the unmanned aircraft due to software limitations. Contributing to the accident was the overly restrictive low voltage threshold limits.NTSB WPR23LA139Accident · No injuriesClass 4 · LimitedFinal reportFiedler Mark R PA-18 Replica · Sandy Valley, NVThe pilot’s failure to maintain airplane control during an off airport precautionary landing on soft soil, which resulted in a nose over.NTSB ERA23LA132Accident · Serious injuriesClass 3 · LimitedFinal reportStilp Tanner E Savannah S · Trenton, SCThe loss of control during the base turn to final due to the impingement of the Y-stick control by a notepad.NTSB DCA23LA192IncidentClass 4 · LimitedFinal reportLearjet 60 · Boston, MAThe Hop-a-Jet flight crew taking off without a takeoff clearance which resulted in a conflict with a JetBlue flight that had been cleared to land on an intersecting runway.NTSB WPR23LA111Accident · Serious injuriesClass 4 · LimitedFinal reportGlasair Sportsman · Cal-Nev-Ari, NVThe pilot’s improper decision to takeoff with known damage to the wing and his failure to maintain directional control during takeoff on rough terrain.NTSB CEN23LA109Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Montevideo, MNThe pilot’s failure to maintain directional control during the landing roll.NTSB DCA23LA133Incident · No injuriesClass 3 · LimitedFinal reportBoeing 777-222 · Honolulu, HIThe airport’s continued use of taxiway Kilo, despite an identified risk of pilots repeatedly failing to stop at a hold short line prior to two intersecting runways. Contributing were 1) the operator’s moving map display, which omitted a published restriction…NTSB WPR23LA064Accident · No injuriesClass 4 · LimitedFinal reportArado-Flugzeugwerke FW190 A-5 · Casa Grande, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA23LA073Accident · No injuriesClass 3 · LimitedFinal reportChilds Michael A Rotorway Exec 162-F · Titusville, FLA failure of the No. 4 exhaust valve spring retainer, which resulted in a partial loss of engine power.NTSB CEN23LA037Accident · Minor injuriesClass 3 · LimitedFinal reportFairchild SA227-AT · Pewaukee, WIThe flight crew’s failure to maintain adequate airspeed and their exceedance of the airplane’s critical angle of attack during the instrument approach, which resulted in an aerodynamic stall. Contributing to the accident was an undetermined anomaly in the…NTSB ERA23FA045Accident · 2 fatalClass 3 · FieldFinal reportBearhawk Patrol · Hanover Township, PAThe pilot’s decision to unlatch his seatbelt during flight, which allowed him to exit the airplane and impact the tail, resulting in a loss of control and impact with terrain.NTSB ERA23LA015Accident · Minor injuriesClass 4 · LimitedFinal reportST Clair David L Tango 2 · Yulee, FLThe pilot’s improper landing flare which resulted in a hard, bounced landing that damaged the nose landing gear, resulting in an inability to maintain directional control and subsequent runway excursion.NTSB ERA23LA013Accident · No injuriesClass 3 · LimitedFinal reportSchempp-Hirth Discus CS · Woodstock, VAImproper repair of a crack by maintenance personnel, which resulted in a subsequent failure of the glider canopy.NTSB ERA23LA010Accident · Serious injuriesClass 4 · LimitedFinal reportGreen L/Gilner D RV-4 · Rowlesburg, WVThe pilot's failure to maintain an appropriate airspeed/angle-of-attack during the landing approach, which resulted in an aerodynamic stall, and impact with terrain.NTSB CEN23LA006Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International S53A · Albuquerque, NMThe pilot’s inability to find a suitable landing area in a critical fuel situation and his decision to land on a highway, which resulted in the balloon impacting a bridge railing and terrain.NTSB CEN22LA438Accident · No injuriesClass 4 · LimitedFinal reportShirey David A Fisher Celebrity · Haskell, OKThe inflight fire for reasons that could not be determined.NTSB WPR22LA366Accident · No injuriesClass 4 · LimitedFinal reportArter Warren Carbon CUB CCK-1865 · Willard, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Winterville, NCThe student pilot’s improper recovery from a bounced landing. A factor in the accident was the instructor’s delayed remedial action which resulted in an inability to recover the airplane from an aerodynamic stall.NTSB GAA22WA297AccidentClass 5 · ForeignDan Hawken Titan T-51 · Soest, GermanyNTSB ERA22LA420Accident · Minor injuriesClass 4 · LimitedFinal reportYakovlev YAK-55M · Waldo, FLThe pilot’s inadequate preflight fuel planning and preflight inspection of the airplane, which resulted in fuel exhaustion, a total loss of engine power, and the subsequent off-airport landing.NTSB WPR22FA332Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Galt, CAThe certified flight instructor's failure to maintain control of the airplane and inadequate supervision of the flight, which resulted in an aerodynamic stall/spin from which he could not recover.NTSB WPR22LA370Accident · No injuriesClass 4 · LimitedFinal reportAlisport Silent 2 Electro · Hood River, ORThe pilot’s improper landing flare which resulted in a hard landing. Contributing to the accident was the pilot’s failure to follow the checklist to remove the wing wheel and tail dolly before takeoff.NTSB ERA22LA400Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Marysville, OHThe pilot’s failure to maintain directional control during landing.NTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.NTSB ERA22FA384Accident · 2 fatalClass 3 · FieldFinal reportMXR Technologies MX2 · Osteen, FLThe pilot’s loss of airplane control while performing aerobatic maneuvers, which resulted in the airplane entering an inverted flat spin that continued until the airplane impacted terrain.