Lycoming AEIO-320 series
NTSB investigations · 20
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 ('41500', '41567')
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 ('41500', '41567')
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 WPR26LA260Accident · Minor injuriesClass 4 · LimitedInvestigation openBellanca 8KCAB · Auburn, CANTSB CEN26LA135Accident · No injuriesClass 4 · LimitedInvestigation openBellanca 8KCAB · Trinidad, CONTSB CEN23LA205Accident · Serious injuriesClass 3 · LimitedFinal reportBellanca 8KCAB · Larchwood, IAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack during initial climb after takeoff, which resulted in an aerodynamic stall and impact with the ground.NTSB GAA18CA253Accident · No injuriesData collectionFinal reportCessna 172 · Glendale, AZThe student pilot’s failure to maintain runway alignment during takeoff, which resulted in an aborted takeoff and runway excursion.NTSB GAA17CA234Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Stafford, KSThe pilot's failure to maintain directional control during the takeoff roll.NTSB ERA11CA477Accident · No injuriesData collectionFinal reportPitts Special · Bessemer, ALThe pilot's failure to maintain directional control during the landing roll.NTSB LAX07CA120Accident · No injuriesData collectionFinal reportCarpenter Lancair 320 · Los Angeles, CAcontamination of the number 2 fuel injector nozzle that lead to a partial loss of engine power.NTSB ANC05CA115Accident · No injuriesData collectionFinal reportPiper PA-18 · Port Heiden, AKThe pilot's misjudged distance/altitude during final approach, which resulted in an undershoot and an in-flight collision with terrain.NTSB LAX96LA176Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Tucson, AZfailure of the pilot to adequately compensate for gusting crosswind conditions and to maintain directional control. A factor in the accident was unattended construction equipment parked in close proximity to the runway edge.NTSB LAX95LA156Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Tucson, AZthe pilot's inadequate compensation for the prevailing wind conditions which resulted in an inadvertent ground loop. The crosswind and the pilot's lack of familiarity with the aircraft are factors in this accident.NTSB MIA95LA003Accident · No injuriesLimited investigationFinal reportPitts S1C · Plant City, FLThe failure of the pilot in command to maintain directional control during landing resulting in the aircraft running off the side of the runway and nosing over in soft terrain.NTSB NYC85FA185Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Fall River, MAWitnesses observed the acft execute an aerial pick up of the aerial advertising banner & climb very steeply away from the ground. Normal eng sounds were reported by the witnesses. The acft was observed to climb to an alt of approx 150 ft, nearly come to a…NTSB ATL85LA114Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Charleston, WVThe plt landed long on the rwy & at excessive speed. In an attempt to stop the acft she applied brakes & the acft flipped upside down.NTSB LAX82FA225Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Westley, CAThe plt made a low pass over a ranch house traveling from nw to se. He then made a second low pass over the swimming pool area traveling in a NE direction, & waved to those standing by the pool. The acft began a 180 reversal turn, entered a steep nose down…NTSB MKC82FCD07Accident · 1 fatalFinal reportBellanca 8KCAB · Fairfield, IAThe pilot stated that he intended to fly down the runway to have a photographer take pictures to be used in publicity for airshows. After several passes (one inverted), the pilot landed to talk with the photographer. The photographer stated they agreed that a…NTSB LAX81FUJ11Accident · 1 fatalClosedBellanca 8KCAB · Bouse, AZNTSB IAD79DKM06Accident · No injuriesClosedBellanca 8KCAB · Greensboro, NCNTSB MKC77FER61Accident · No injuriesClosedPitts S-1S · Jordan, MNNTSB MKC77FER20Accident · No injuriesClosedBellanca 7KCAB · Pine City, MNNTSB FTW76FQG94Accident · Serious injuriesClosedBellanca 8KCAB · Acuff, TX
Back to Lycoming AEIO-320 series