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 MIA86FA097Accident · 2 fatalField investigationFinal reportMcfarland Quickie 2 · Mulberry, FLWitnesses reported that the acft was flying at a lower than normal altitude and at full throttle when something broke off the acft. The acft then rolled to the right, went almost straight up and spiraled down striking the ground inverted. Post crash…NTSB CHI85LA332Accident · Minor injuriesLimited investigationFinal reportMcfarland Quickie 2 · Port Clinton, OHThe pilot failed to release the parking brakes before landing after setting the brakes while enroute. The acft swerved off the runway and nosed over.NTSB CHI85LA240Accident · Serious injuriesLimited investigationFinal reportHaney Polliwagon · Lambertville, MIThe plt was unable to flare the acft with full up elevator and the nose gear contacted the rwy during landing. The acft bounced and contacted the rwy again resulting in a gear collapse. The plt stated that the elevator did not provide the same amount of up…NTSB DEN85FTI01Accident · 1 fatalFinal reportPolliwagen 2 Place · Manhattan, MTThe acft crashed in an open flt shortly after takeoff and was destroyed by fire. There were no witnesses to the accident. The plt reportedly stated he needed to depart Manhattan by 0500 MST to arrive in helena before 0600 MST when the ATC twr opened as his…NTSB LAX85FUG02Accident · No injuriesFinal reportCorlett-Beahm KR-2 · Riverside, CAThe acft nosed over in a field during a forced landing following a loss of power which occurred for unknown reason(s).NTSB SEA84LA231Accident · No injuriesLimited investigationFinal reportDrake Quickie II · Twin Falls, IDThe plt said that the acft porpoised 2 or 3 times after initial touchdown. After bouncing, the acft veered to the rt, ground looped and nosed over after contacting the soft ground off the side of the rwy.NTSB CHI84LA381Accident · No injuriesLimited investigationFinal reportUngerecht Q-2 · Appleton, WIAfter takeoff on the third flight of the new homebuilt aircraft the pilot smelled 'something hot' and noted a high cylinder head temp. During the subsequent precautionary landing the plt flared the acft 3-4 ft above the rwy resulting in a hard landing and…NTSB ATL84LA219Accident · No injuriesLimited investigationFinal reportHaxton Quickie Q2 · Kennesaw, GAThe home built acft had just been constructed & the plt was making hi speed taxi checks. On the 3rd check, he applied full power, intending to accelerate to a target speed of 60 mph. He reduced the power before reaching that speed; however, the acft…NTSB CHI83LEE01Accident · No injuriesFinal reportQuickie Q-2 · Chicago, ILThe plt reported that during an en route stop, the acft landed hard, then bounced & was damaged in the area of the tailwheel. Reportedly, the tailwheel spring separated, the rudder pedals flopped forward & control of the rudder was lost. Subsequently, the…NTSB DEN83LTG02Accident · No injuriesFinal reportAleson Quickie Q2 · Williston, NDThe acft groundlooped and collided with a rwy light following an inadvertant takeoff and landing during what was supposed to be a high speed taxi test. During the landing roll the acft swerved to the left, departed the rwy and collided with a rwy light. This…NTSB CHI83LA187Accident · No injuriesLimited investigationFinal reportTuk Gregory Quickie Q-2 · Ann Arbor, MIThe home built acft was on its 1st test flt. According to the plt, the throttle became bound when he attempted to add power after checking the stall characteristics. Reportedly, the eng lost power at about this time when a rapid throttle movement was made.…NTSB LAX83FUG10Accident · Serious injuriesFinal reportNorman Negus KR-2 · Hemet, CAThe owner of the home built aircraft was checking out the other pilot who was second-in-command (SIC). The SIC also had a home built of the same make and model. The objective was to provide familiarization to the SIC. During an approach to land, they elected…NTSB CHI82DA131Accident · No injuriesFinal reportHartman KR-II · Columbus, OHOn final approach the aircraft settled and collided with trees that were located approximately 75 ft from the approach end of the runway. The pilot stated that he allowed his airspeed to become too slow and that he applied power but the right wing caught a…NTSB LAX81FUA09Accident · Minor injuriesClosedRand KR2 · Huntington Bch, CANTSB SEA80DYA04Accident · No injuriesClosedAerosport Quail · Idaho Falls, ID
Back to Revmaster 2100