Lycoming IO-360-A1A
NTSB investigations · 22
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 ('41818')
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 ('41818')
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 ERA26LA351Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182S · St. Petersburg, FLNTSB WPR24LA272Accident · Minor injuriesClass 4 · LimitedFinal reportRenquist George GS-2 Sportsman · Hawthorne, CAThe flight crew’s failure to maintain airspeed during a short field landing and the instructor’s delayed remediation, which resulted in a hard landing.NTSB WPR24FA010Accident · 1 fatalClass 3 · FieldFinal reportRobert L Thurmond RV8 · Centerville, UTThe pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the departure airport, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the failure of the No. 2…NTSB WPR23LA235Accident · No injuriesClass 4 · LimitedFinal reportJohn Topliff PA18-200EXP · Truckee, CAThe pilot’s loss of directional control on landing roll out, during variable wind conditions.NTSB WPR23FA007Accident · 1 fatalClass 3 · FieldFinal reportCornford Craig H Mustang II · Jamul, CAImpact with mountainous terrain for undetermined reasons due to the limited evidence that could be collected from the accident sceneNTSB CEN17FA067Accident · 1 fatalField investigationFinal reportDemmer BD-4 · Brookfield, WIThe pilot's failure to abort the takeoff when he was not able to maintain directional control in the strong crosswind conditions.NTSB ERA15CA364Accident · Minor injuriesData collectionFinal reportHughes 269B · Hartford, ALThe pilot's inadequate preflight planning, and his subsequent failure to attain adequate altitude during takeoff, which resulted in a collision with a wire fence.NTSB GAA15CA060Accident · No injuriesData collectionFinal reportWatson David E Skybolt · Carson City, NVThe pilot's failure to maintain directional control of the airplane during takeoff, resulting in substantial damage to the airplane.NTSB WPR15LA101Accident · Minor injuriesLimited investigationFinal reportVans RV7 - Undesignat · Belfair, WAA total loss of engine power during cruise flight due to the fatigue failure of the engine crankshaft. Contributing to the accident was the unapproved repair and improper inspection of the engine crankshaft.NTSB CEN13CA434Accident · No injuriesData collectionFinal reportDavid W Oakes RV-7A · Charlottesville, INThe improper landing attitude which damaged the nosewheel and a resulted in a hard landing.NTSB WPR13LA002Accident · 1 fatalLimited investigationFinal reportWood Mustang II FB · San Manuel, AZThe pilot's failure to maintain adequate airspeed while maneuvering to final approach due to his distraction by the low engine oil pressure, which resulted in an aerodynamic stall.NTSB CEN11CA560Accident · No injuriesData collectionFinal reportCessna 182S · Los Cruces, NMThe pilot's loss of aircraft control due to insufficient aircraft performance during takeoff, with a heavy gross weight and a high density altitude.NTSB WPR11LA143Accident · No injuriesLimited investigationFinal reportMooney M20F · Nephi, UTThe failure of the nose gear during landing for reasons that could not be determined due to postaccident damage.NTSB NYC08CA048Accident · Serious injuriesData collectionFinal reportVans RV-8 · Latrobe, PAThe pilot's failure to maintain directional control during landing.NTSB ATL07CA123Accident · No injuriesData collectionFinal reportVans Vans RV-6 · Stockbridge, GAThe pilot's failure to maintain airplane control during the landing roll.NTSB SEA07CA197Accident · No injuriesData collectionFinal reportCessna 182S · Astoria, ORThe pilot's failure to maintain directional control during the landing flare/touchdown, resulting in an inadvertent swerve and collapse of the left main and nose landing gears.NTSB ATL07LA034Accident · No injuriesLimited investigationFinal reportGreenhaw, William Lancair 360 · Guntersville, ALFailure of an unapproved automotive fuel line installed by the owner/pilot mechanic which resulted in an engine fire during taxi after landing.NTSB DEN05LA070Accident · No injuriesLimited investigationFinal reportRoss/Stonecipher Vans RV-6 · Longmont, COthe loss of engine power due to oil starvation. A contributing factor was the contamination in the inverted oil system's separator.NTSB CHI02LA264Accident · No injuriesLimited investigationFinal reportCessna 182S · Fishers, INThe pilot failed to maintain clearance with the light pole while taxiing. A factor was the light pole.NTSB SEA97LA145Accident · Minor injuriesLimited investigationFinal reportRoss/Stonecipher Vans RV-6 · Woods Cross, UTa bird strike, which penetrated the aircraft canopy. High grass (hay crop) in the forced landing area was a related factor.NTSB SEA95LA201Accident · No injuriesLimited investigationFinal reportBristol RV-6 · Grants Pass, ORa loss of engine power for undetermined reasons.NTSB CHI90LA129Accident · No injuriesLimited investigationFinal reportCecil, Richard C. Starduster II · Indianapolis, INThe other pilot's inadequate visual lookout during ground taxi operations.
Back to Lycoming IO-360-A1A