Revmaster 2100
NTSB investigations · 65
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 ('52550')
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 ('52550')
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 CEN21LA419Accident · Minor injuriesClass 4 · LimitedFinal reportThatcher CX4 · Marshalltown, IAThe pilot’s failure to properly determine the correct fuel quantity during preflight inspection that resulted in a loss of engine power during approach due to fuel exhaustion.NTSB WPR20CA221Accident · No injuriesClass 4 · Data collectionFinal reportQuickie Q2 · Preston, IDThe pilot's failure to maintain airplane control during takeoff in high density altitude conditions, which resulted in a collision with terrain. Contributing to the accident was the pilot's failure to accomplish performance calculations for the atmospheric…NTSB ERA18FA005Accident · 1 fatalField investigationFinal reportBryant C Crosby BC Ultra PUP · Bardstown, KYThe pilot's improper decision to initiate a flight in an airplane he had never flown and with no currency in any airplane nor a medical certificate, which resulted in his loss of airplane control. Contributing to the accident was the pilot's psychiatric…NTSB GAA16CA274Accident · Minor injuriesData collectionFinal reportKoons Donald H Cygnet · Zanesville, OHThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, and a nose over.NTSB GAA15CA203Accident · No injuriesData collectionFinal reportWelch Floyd L Quickie Q 2 · Hazleton, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.NTSB ERA13LA119Accident · Serious injuriesLimited investigationFinal reportShoemaker James B KR-2 · Palmetto, FLThe total loss of engine power for undetermined reasons, which resulted in a forced landing.NTSB CEN11CA326Accident · No injuriesData collectionFinal reportGetten Marvin T Quickie Q2 · Albuquerque, NMThe pilot's loss of elevator control, due to control stick's counter-weight binding with the airplane's header tank.NTSB WPR11FA155Accident · 1 fatalField investigationFinal reportMuse KR2 · Newberry Springs, CAThe airplane’s encounter with severe turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB CEN11CA046Accident · No injuriesData collectionFinal reportHughes J/Hughes J Rand-Robinson · Pearland, TXThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was an engine oil leak which partially obscured the pilot’s forward vision.NTSB WPR10LA445Accident · Serious injuriesLimited investigationFinal reportMorehead KR-2 · Rancho Murieta, CAThe pilot’s improper flare and recovery from a bounced landing.NTSB WPR10CA181Accident · No injuriesData collectionFinal reportMorrison Joseph Q2 · Frazier Park, CAA partial loss of engine power likely due to the failure of the oil pump.NTSB LAX08CA119Accident · No injuriesData collectionFinal reportCarlson Quickie Q2 · Casper, WYA loss of directional control on landing due to the separation of the wing leveler trim knob and resulting reduced aileron control.NTSB SEA07CA271Accident · Minor injuriesData collectionFinal reportLangley Tri-Quickie · Chino, CAThe premature rotation of the airplane on the takeoff roll as a result of the pilot failing the verify the elevator trim position, resulting in a loss of control and subsequent impact with terrain during an aborted takeoff.NTSB CHI07LA080Accident · 1 fatalLimited investigationFinal reportWood Quickie Q-2 · Edwardsville, ILThe loss of engine power during cruise due to loose cylinder head bolts/loose cylinders.NTSB LAX06LA266Accident · 1 fatalLimited investigationFinal reportSaloff Sonerai Iilt · Williams, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB SEA06LA040Accident · No injuriesLimited investigationFinal reportHolscher KR II · McNeil Island, WAFuel exhaustion while in cruise flight due to inaccurate fuel quantity indications. Factors included the pilot's failure to positively determine the quantity of fuel onboard the aircraft during preflight, and rough, uneven grassy terrain at the location where…NTSB SEA04LA046Accident · Minor injuriesLimited investigationFinal reportJerome Q-2 · Hillsboro, ORThe pilot's inadequate evaluation of deteriorating weather conditions (increasing rain) and his failure to maintain the proper rate of descent on landing (long/hard touchdown). Contributing factors were carburetor icing conditions and rain.NTSB LAX02LA051Accident · No injuriesLimited investigationFinal reportVernon Sonerai IIL · Camarillo, CAFailure of the pilot to maintain directional control on the landing rollout. Factors were the owner/pilot's inadequate remedial design changes and the freshly plowed field.NTSB SEA01LA123Accident · Minor injuriesLimited investigationFinal reportBreiter Aerosport Quail · Idaho Falls, IDThe pilot's failure to maintain an airspeed above stall velocity (Vs) during his attempt to stretch a reduced power forced landing glide. Factors include fuel starvation, a partial loss of power due to fuel contamination, and the pilots inadequate preflight…NTSB SEA00LA068Accident · No injuriesLimited investigationFinal reportPZL-Bielsko SZD-45A Ogar · Libby, MTA crack in the propeller blade that developed into a complete separation of the blade.NTSB LAX00LA139Accident · No injuriesLimited investigationFinal reportScovil KR-2 · Tonopah, AZThe fuel control metering unit becoming disengaged and the inadvertent use of the fuel supply during flight.NTSB CHI00LA082Accident · 1 fatalLimited investigationFinal reportEllis Q2 · Shelbyville, INaircraft control not being maintained by the pilot during the attempted go-around. Factors to the accident were the inadequate preflight by the pilot, which resulted in fuel exhaustion. An additional factor to the accident was the inadvertent stall/mush.NTSB LAX00LA078Accident · Minor injuriesLimited investigationFinal reportMyers Q-2 · Compton, CAFailure of the pilot to maintain directional control of the airplane during the takeoff roll.NTSB LAX99LA303Accident · 1 fatalLimited investigationFinal reportNye KR-2 · Mariposa, CAThe pilot's failure to maintain an adequate airspeed margin while performing an intentional steep right bank turning maneuver, which resulted in a stall/mush and descent into terrain.NTSB CHI99LA127Accident · No injuriesLimited investigationFinal reportReindl Quickie 2 · Olathe, KSThe loss of engine power for undetermined reasons. A factor associated with the accident is the lack of suitable terrain for a forced landing.NTSB LAX98LA265Accident · No injuriesLimited investigationFinal reportRaymond C. Voegele Mini IMP RC-2 · Sonoma, CAA loss of power due to a loose magneto cap and a binding throttle control cable. The deficiencies were the result of the owner/pilot's improper installation and/or adjustments.NTSB SEA98LA134Accident · Minor injuriesLimited investigationFinal reportNelson Cygnet SF-2A · Newberg, ORThe pilot-in-command's failure to maintain directional control. Factors contributing were the pilot-in-command's lack of experience in make of aircraft (i.e., use of toe brakes) and the fence post.NTSB LAX98LA194Accident · No injuriesLimited investigationFinal reportScott Dragonfly · Mecca, CAThe pilot's inadequate preflight inspection and his failure to ensure sufficient fuel was in the airplane, which subsequently led to fuel exhaustion. A related factor was the soft terrain.NTSB SEA96LA212Accident · 1 fatalLimited investigationFinal reportGrazier Quickie 2 · Superior, MTloss of engine power after takeoff for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering to return to the departure airport, which resulted in a stall and collision with wooded terrain.NTSB MIA96LA001Accident · Serious injuriesLimited investigationFinal reportClapp KR-2 · Jacksonville, FLThe pilot's inadequate preflight planning/preparation, failure to ensure proper weight and balance of the airplane, and failure to obtain or maintain sufficient airspeed during takeoff, which resulting in a stall and collision with wooded terrain.NTSB CHI95LA296Accident · No injuriesLimited investigationFinal reportBradley DQ2 · Newton, KSthe pilot's improper recovery from a bounced landing. A factor was the aircraft's inadequate handling capability.NTSB NYC95LA124Accident · 1 fatalLimited investigationFinal reportBailey Quickie Q-2 · Woodsfield, OHThe loss engine power for undetermined reason and the pilot's failure to maintain control which resulted in an inflight collision with terrain.NTSB CHI95LA036Accident · 1 fatalLimited investigationFinal reportLessel KR-2 · Portland, INthe failure of the elevator control cable attach point and the pilot's subsequent inability to control the airplane.NTSB LAX94LA378Accident · No injuriesLimited investigationFinal reportQuickie-Myers Q2 · Van Nuys, CAthe pilot's inadequate landing flare, which resulted in a hard touchdown and buckling of the canard.NTSB CHI93LA368Accident · Minor injuriesLimited investigationFinal reportKewley KR2 · Carbondale, ILImproper planning/decision by the pilot, which resulted in fuel exhaustion due to lack of fuel.NTSB NYC92LA170Accident · No injuriesLimited investigationFinal reportGerald Barker Quicky 2 · Altoona, PAAn onground collision with a VASI light box after the tailwheel strut broke upon touchdown and the pilot lost directional control.NTSB DEN92LA055Accident · 1 fatalLimited investigationFinal reportTakemoto KR-2 · Aurora, COThe pilot failed to maintain airspeed which resulted in an inadvertant stall.NTSB SEA92LA103Accident · No injuriesLimited investigationFinal reportE.E. Shilling Q-2 · Billings, MTAn undetermined loss of engine power.NTSB FTW92LA018Accident · Minor injuriesLimited investigationFinal reportMahan Hardaway Quickie Q2 · Arcola, TXThe pilot's improper flare and improper recovery from the resultant bounced landing. A factor was the pilot's lack of familiarity with the airplane.NTSB MIA90FA043Accident · Serious injuriesField investigationFinal reportTundermann Venne Q-2 · Zephyrhills, FLLoss of engine power for undetermined reasons.NTSB LAX89DUG05Accident · No injuriesFinal reportSalmon KR-2 · Chino, CAThe pilot's overcontrolling of the aircraft. A factor in the accident was that this was the pilot's first flight in the aircraft.NTSB NYC88DGM02Accident · Serious injuriesFinal reportBarker Quickie Q2 · Martinsburg, PAThe pilot reported he was practicing takeoffs and landings, and that he was 'determined to hold the approach speed to 80 and rate of descent to 500 feet per minute . . .' The approach was flown at dusk as light was beginning to fail. The pilot stated, 'I…NTSB CHI88FA177Accident · No injuriesField investigationFinal reportQuickie Q-2 · Oshkosh, WIThe plt was on a flt to Oshkosh to an eaa convention. When he arrived, traffic was hvy & special traffic procedures were in effect. Info to attendees (before the convention) advertised that the north/south rwys would be used primarily for display acft & the…NTSB MKC88LA055Accident · No injuriesLimited investigationFinal reportCarter Quickee 2 · Springfield, MOWhile flying a homebuilt aircraft, under experimental category, the pilot experienced an engine failure. An emergency ldg was made on a highway, and during the ldg roll the acft struck some marker barrels, suffering substantial damage. The pilot said the…NTSB MKC87LA128Accident · No injuriesLimited investigationFinal reportLowder Quickie II · Iowa City, IAThe PIC rptd normal takeoff and climb during a LCL flt. Abt 15 min into the flt, the PIC experienced a nose down pitching. Throttle was reduced and level attitude was established. The PIC rptd difficulty maintaining level flt and made a precautionary lndg on…NTSB ATL87FA016Accident · 1 fatalField investigationFinal reportKoons-Donald Sonerai II · Macon, GADuring climbout, the pilot allowed the aircraft to stall while turning to a left crosswind. The acft impacted the ground in a nose low attitude after colliding with two trees. The pilot was unable to exit the aircraft and local residents were unable to assist…NTSB DEN86LTM03Accident · No injuriesFinal reportQuickie Q-2 · Grand Junction, COThe plt reported that the acft entered a porpoise during landing. While attempting to add power the eng quit. The landing gear then broke off and the acft entered a ground loop and ran off the rwy. The plt notes that the acft has a tendency to bounce during…NTSB DEN86LA228Accident · No injuriesLimited investigationFinal reportE. E. Schilling Q-2 · Billings, MTPlt stated after accident that he had a minor eng problem prior to departure from big timber. He stated that the problem was corrected and the flight commenced to Billings. While on final approach to rwy 04 at Billings the plt experienced a partial loss of…NTSB FTW86FRG29Accident · 2 fatalFinal reportCollins Charles A KR-2 · Georgetown, TXAcft was observed to takeoff, circle the arpt and make a low pass down the departure rwy. Following the low pass the acft entered a steep right bank, stalled and nosed over into the ground. During the investigation, no evidence of mech failure or malfunction…NTSB MKC86LA131Accident · No injuriesLimited investigationFinal reportCharles S.Hatchette Quickie Q2 · Goodland, KSThe pilot experienced a gradual loss of engine power during cruise and made a forced landing to a field. During the landing roll, the plane hit a hole and nosed over. Examination found that a fuel vent line had melted closed in the vicinity of the exhaust…
Back to Revmaster 2100