Lycoming O-320-B2B
NTSB investigations · 25
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 ('42138')
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 ('42138')
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 ANC25LA107Accident · No injuriesClass 4 · LimitedFinal reportDavid Hunter Danchini CUB · Tyonek, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll, in gusting crosswind conditions.NTSB ERA25LA012Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Louisville, KYA total loss of engine power for undetermined reasons.NTSB GAA19CA157Accident · No injuriesData collectionFinal reportPiper PA22 · Superior, WIThe pilot's failure to maintain directional control during landing on a snow- and ice-covered runway, which resulted in impact with a snowbank and a nose-over.NTSB GAA17CA287Accident · No injuriesData collectionFinal reportJohnson Kenneth W Super CUB Sport · Austin, NVThe pilot’s failure to maintain adequate airspeed during landing in gusting wind conditions, which resulted in a loss of directional control.NTSB ANC16CA069Accident · Minor injuriesData collectionFinal reportPiper PA18 · Willow, AKThe pilot's failure to maintain airplane control during the landing roll, which resulted in a nose-over.NTSB GAA16CA458Accident · No injuriesData collectionFinal reportPiper PA18 · Central, AKThe pilot's decision to taxi on unsuitable terrain after landing, which resulted in an encounter with a washed out ditch.NTSB GAA16CA347Accident · No injuriesData collectionFinal reportPiper PA 12 · Burnet, TXThe student pilot's failure to maintain adequate fuel levels, which resulted in fuel starvation, a loss of engine power, and a forced landing. Contributing to the accident was the flight instructor's failure to monitor the fuel levels.NTSB WPR14FA283Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Landmark, IDThe failure of the overtaking airplane’s pilot to maintain visual contact and separation from the airplane being overtaken.NTSB ERA12CA204Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCAA · Bedminster, NJThe pilot receiving instruction’s inadvertent movement of the pitch trim control to the nose-down position while attempting a go-around.NTSB CEN11CA060Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · Watertown, SDThe pilot's inadvertent and premature use of the brakes during the landing roll, which resulted in a nose-over.NTSB ERA10LA207Accident · 1 fatalLimited investigationFinal reportLuciano Edison HA-2 Sportster · Humacao, PRThe failure of the pilot to maintain control of the gyrocraft while maneuvering after takeoff. Contributing to the accident was the pilot’s operation of the gyrocraft with an inoperative right magneto.NTSB NYC08LA249Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Surfside Beach, SCA loss of engine power due to carburetor icing. Contributing to the accident was the obstruction of the carburetor heat flapper by a mud dauber's nest.NTSB LAX07CA100Accident · Minor injuriesData collectionFinal reportHirsch Thorp T-18 · San Diego, CAThe pilot's improper bounced landing recovery and improper use of the flight controls that resulted in a porpoise and a nose over.NTSB SEA07CA045Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Maricopa, AZThe excessive brake application during landing which resulted in a nose over.NTSB ATL06CA011Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Bennettsville, SCThe malfunction of the wheel brake assembly due to low fluid level that resulted in a loss of control during the landing roll.NTSB ANC02LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's inadequate supervision of the flight. Factors in the accident were the student's failure to maintain directional control of the airplane during the landing roll, icy runway conditions, and snow-covered terrain along the runway edges.NTSB NYC99LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Greenville, METhe pilot in command's inattentive management of the fuel supply.NTSB CHI98LA273Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Clearwater, MNThe inadequate visual lookout by the pilot-in-command. The unmarked transmission wire was a contributing factor.NTSB ANC95LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKThe pilot-in-command's failure to maintain airspeed.NTSB CHI77FEI21Accident · No injuriesClosedGrum Amer AA-1B · Bowling Green, OHNTSB ANC75AA083Accident · Minor injuriesClosedPiper PA-18 · Selawik, AKNTSB ANC75DAG07Accident · No injuriesClosedPiper PA-18 · Tyonek, AKNTSB MIA71DKG81Accident · No injuriesClosedPiper PA-28 · Ashburn, GANTSB MKC69F0095Accident · Minor injuriesClosedPiper J3C · Austin, MNNTSB CHI66F0133Accident · No injuriesClosedPiper PA-18A · Douglas, MI
Back to Lycoming O-320-B2B