Franklin 4AC176B series
NTSB investigations · 30
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 ('27006')
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 ('27006')
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 CEN22LA199Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-65 · Port Bolivar, TXThe pilot’s failure to maintain directional control during takeoff.NTSB CEN16LA239Accident · Minor injuriesLimited investigationFinal reportPiper J3F 65 · Strasburg, COA partial loss of engine power due to carburetor ice accumulation.NTSB ANC12CA081Accident · No injuriesData collectionFinal reportPiper J3F-65 · Beluga, AKThe pilot's delayed decision to go around, which resulted in a hard landing.NTSB CHI07CA186Accident · No injuriesData collectionFinal reportPiper J3F-65 · Grand Ledge, MIThe pilot's failure to maintain directional control during takeoff resulting in a ground loop.NTSB CHI05LA250Accident · 1 fatalLimited investigationFinal reportPorterfield FP-65 · Sedalia, MOThe pilot's failure to maintain sufficient airspeed and the inadvertent stall/spin resulting in an in-flight loss of control and collision with terrain.NTSB ATL02LA086Accident · No injuriesLimited investigationFinal reportPiper J-3 · Carrollton, GAThe pilots failure to maintain flying speed that resulted in an inadvertent stall.NTSB NYC01LA156Accident · No injuriesLimited investigationFinal reportPiper J3F-65 · Findlay, OHTwo chafed ignition switch leads, which resulted in a failure of the ignition system and subsequent total loss of engine power.NTSB SEA01LA103Accident · No injuriesLimited investigationFinal reportPiper J3F-65 · Brush Prairie, WAThe first pilot's failure to maintain aircraft control during a high-speed taxi maneuver. Tall grass adjacent to the runway was a factor.NTSB ATL92LA183Accident · 1 fatalLimited investigationFinal reportCorben Baby ACE · Jacksonville, NCThe pilot's failure to maintain flying speed which resulted in a loss of control and an inadvertent stall and collision with the ground.NTSB NYC91LA013Accident · Minor injuriesLimited investigationFinal reportPorterfield Porterfield FP65 · Moravia, NYPower loss after takeoff due to a partially clogged fuel line between the fuel tank and the gascolator. Contributing to the accident was unsuitable terrain under the airplane when power loss occurred.NTSB ATL86FEI05Accident · No injuriesFinal reportPiper J3 · Wauseon, OHThe plt reported that he was landing on rwy 27 with the wind from about 190 degrees at 15 mph, gusting to 23 mph; he executed a normal ldg and was rolling out when a gust of wind lifted up the left wing and the acft ground-looped. The acft subsequently…NTSB LAX86LA023Accident · No injuriesLimited investigationFinal reportPiper J3 · Green Valley, AZOn oct 24, 1985, a Piper J3 cub,N33461, made an emergency landing in rough, open terrain near Green Valley, AZ. After experiencing a loss of engine power the ac sustained substantial damage and the pvt plt was not injured. The investigation revealed that the…NTSB ANC85LA122Accident · No injuriesLimited investigationFinal reportTaylorcraft DF-65 · Eklutna, AKAcft landed hard, collapsing both main landing gear after making a steep apch to a short area on a gravel road. Plt was landing to drain some acft fuel out in order to get better climb performance for a mountain sightseeing flight.NTSB LAX82DA087Accident · Minor injuriesFinal reportPiper J3-F65 · Yerington, NVDuring final approach for a hard dirt field the pilot reported that the bottom fell out and he hit short resulting in substantial damage to the aircraft.NTSB LAX78DUG17Accident · Minor injuriesClosedHammock DSA1 · Barstow, CANTSB MIA77FKG57Accident · Minor injuriesClosedPiper J-3 · Athens, GANTSB SEA76DYI19Accident · Minor injuriesClosedPiper J-3 · Central Point, ORNTSB MKC76DER34Accident · No injuriesClosedPiper J-3 · Caledonia, MNNTSB CHI76FEC09Accident · No injuriesClosedPiper J3F-65 · Blissfield, MINTSB FTW74DPJ33Accident · No injuriesClosedPiper J-3 · Alva, OKNTSB MIA74FLD59Accident · Serious injuriesClosedPiper J3 · Titusville, FLNTSB NYC74DGM03Accident · No injuriesClosedTaylorcraft BF1265 · Meadville, PANTSB SEA71FDG03Accident · No injuriesClosedPiper J3 · Cut Bank, MTNTSB NYC70D0222Accident · No injuriesClosedTaylorcraft BC-12 · New Salem, NYNTSB MKC69F0370Accident · No injuriesClosedPiper J3F-65 · Sargeant, MNNTSB FTW69F0184Accident · No injuriesClosedAeronca 65-TAF · Fort Worth, TXNTSB ANC67D0048Accident · No injuriesClosedPiper J-3 · Dillingham, AKNTSB CHI66F0707Accident · No injuriesClosedPiper J3 · Grand Ledge, MINTSB UNK64X2733Accident · No injuriesClosedTaylorcraft DF65 · Escondido, CANTSB UNK64X1890Accident · 1 fatalClosedPiper J3F-65 · Dixie, ID
Back to Franklin 4AC176B series