Lycoming R680-4P-B4
NTSB investigations · 47
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 ('41542')
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 ('41542')
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 CEN26LA182Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Waco, TXThe pilot’s failure to maintain directional control during the landing with a crosswind.NTSB ERA23LA381Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75 · Erwinna, PAThe pilot’s failure to maintain control of the airplane while taking off in a crosswind.NTSB CEN21LA343Accident · Minor injuriesClass 3 · LimitedFinal reportStinson JR. SR · Ripon, WIA total loss of engine power due to fuel starvation.NTSB WPR21LA208Accident · Minor injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Hollister, CAThe improper installation of a relief valve spring that was shorter than the standard spring length, which slowed the response of the propeller governor to change the pitch of the blades during climbout, resulting in a partial loss of power.NTSB CEN16FA116Accident · 2 fatalField investigationFinal reportCurtiss Wright Travel AIR 4000 · Palmer Lake, COThe pilot's failure to maintain sufficient airspeed while maneuvering at low altitude in strong gusting winds, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's…NTSB ERA14CA395Accident · No injuriesData collectionFinal reportBoeing E75N1 · Penridge, PAThe pilot's delayed action in correcting a drift to the right during landing roll and his improper use of the wheel brakes which resulted in the airplane nosing over.NTSB ERA13LA054Accident · No injuriesLimited investigationFinal reportBoeing E75 · Williamson, GAThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision.NTSB CEN11LA375Accident · No injuriesLimited investigationFinal reportBoeing A75N1(PT17) · Junction City, KSThe degraded engine performance due to low compression on the cylinder and delayed ignition timing.NTSB ERA10CA465Accident · No injuriesData collectionFinal reportStearman E75 · Jackson, GAThe pilot's diverted attention toward an unsecured engine cowl door after takeoff which resulted in his failure to maintain airspeed and altitude. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.NTSB NYC07LA124Accident · 2 fatalLimited investigationFinal reportBoeing Stearman A75N1 · Charleston, SCAn in-flight collision with water for undetermined reasons.NTSB LAX06LA056Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Corona, CAfailure of both pilots to see and avoid each other during traffic pattern operations at a non-towered airport.NTSB FTW94LA254Accident · Serious injuriesLimited investigationFinal reportBoeing A75 · Comfort, TXThe pilot's inadequate compensation for the crosswind and his failure to push the propeller lever full forward. Factors were the crosswind and the pilot's failure to follow the before takeoff checklist.NTSB FTW89LA130Accident · No injuriesLimited investigationFinal reportStinson V77 · El Paso, TXPilot's failure to maintain directional control during landing roll in a high crosswind environment.NTSB ATL89LA069Accident · No injuriesLimited investigationFinal reportBoeing E75 · Salisbury, NCImproper use of carburetor heat by the pilot, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions and obstruction(s)/utility pole near the departure end of the runway.NTSB FTW88DRG08Accident · No injuriesFinal reportBoeing Stearman E-75 · Fisher, TXAfter touchdown, the pilot stated that he lost directional control and the right main gear ran off the right side of the runway. During attempted recovery, the airplane rolled off the left side of the runway, collided with a drainage ditch and nosed over to…NTSB MKC88LA006Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Creve Coeur, MOWhile practicing stop and go ldgs, plt lost control during rollout. Acft swerved and entered an inadvertent ground loop. The right main landing gear failed and the right lower wing contacted the ground.NTSB FTW86LA087Accident · No injuriesLimited investigationFinal reportBoeing PT-13/E-75 · Dallas, TXThe plt had just departed the arpt, started to turn crosswind at 500 ft and began climbing, when the eng started sputtering and lost pwr. He did not have enough alt to return to the arpt and had to ditch the acft 200 yds off the north end of the rwy. No…NTSB DEN85LA139Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Grand Junction, COThe plt reported that as he arrived at the destination (canyonlands, UT), there was a storm over the arpt, so he diverteded toward delta, CO. About 10 mi from delta, he encountered another storm, so he turned toward Grand Junction, CO. Before reaching the…NTSB NYC82DNC12Accident · No injuriesFinal reportBoeing PT-17 · Hamlin, METhe pilot departed a private strip with 150 gallons of water mixed with fungicide and insecticide. After takeoff, he turned and began climbing over rising terrain. The terrain sloped upward from a river, rising about 400 ft. the pilot reported that he failed…NTSB FTW80FPG37Accident · No injuriesClosedBoeing PT-13D · N Little Rock, ARNTSB MIA80DLG08Accident · No injuriesClosedBoeing A75N1 · Columbia, SCNTSB NYC78FHA34Accident · No injuriesClosedStearman PT-17 · Pottstown, PANTSB LAX78FUJ82Accident · Serious injuriesClosedTravel Air 4000 · Tolleson, AZNTSB NYC76FNC55Accident · No injuriesClosedBoeing A75N1 · Belmont, MENTSB LAX76FUG58Accident · Serious injuriesClosedStinson V-77 · 29 Palms, CANTSB FTW76FQD23Accident · No injuriesClosedStinson V-77 · El Paso, TXNTSB LAX76FUQ14Accident · No injuriesClosedStinson V-77 · Pacoima, CANTSB OAK75DVG48Accident · No injuriesClosedStearman A75N1 · Orland, CANTSB FTW75DPG40Accident · No injuriesClosedBoeing E75N1 · West Helena, ARNTSB OAK75IP019Incident · No injuriesClosedBoeing 747 · Honolulu, HINTSB MIA75FKG19Accident · Minor injuriesClosedBoeing A75N1 · Blakely, GANTSB LAX75FUG01Accident · Minor injuriesClosedNaval Fcty N3N-3 · Lucerne, CANTSB MKC73DCA19Accident · No injuriesClosedBoeing A75-N1 · Campbell, MONTSB CHI73DEE23Accident · No injuriesClosedBoeing B75N1 · Wheeling, ILNTSB FTW72FPG40Accident · No injuriesClosedBoeing E75N1 · Aubrey, ARNTSB OAK70DVG07Accident · No injuriesClosedBoeing E-75 · Willows, CANTSB MIA70D0119Accident · No injuriesClosedBoeing A75 · West Columbia, SCNTSB LAX69F0343Accident · Minor injuriesClosedTravelair 4000 · El Mirage, AZNTSB FTW69D0205Accident · No injuriesClosedBoeing A75 · Bradley, ARNTSB FTW66F0673Accident · No injuriesClosedBoeing A7571 · Kaplan, LANTSB MIA66F0389Accident · No injuriesClosedBoeing PT-13 · Atlanta, GANTSB MIA66F0208Accident · Minor injuriesClosedBoeing A-75 · Mattson, MSNTSB NYC66D0047Accident · No injuriesClosedStinson SM-8A · Provincetown, MANTSB UNK64X4045Accident · No injuriesClosedBoeing 75N1 · Lepanto, ARNTSB UNK64X3733Accident · No injuriesClosedBoeing E75N1 · Hazen, ARNTSB UNK64X1658Accident · Minor injuriesClosedStearman E75N1 · Henry County, ALNTSB UNK64X1498Accident · No injuriesClosedBoeing A75 · Ville Platte, LA
Back to Lycoming R680-4P-B4