Final NTSB investigations: Ivchenko AL-25SERIES
10 cases on aircraft whose registry engine model is Ivchenko AL-25SERIES. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1998 | 1 |
|---|---|
| 2001 | 3 |
| 2003 | 1 |
| 2007 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 1 |
Where
Open the mapLatest cases
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('34702'))
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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('34702'))
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 ERA16LA322Accident · No injuriesLimited investigationFinal reportAero Vodochody L 39 · Norfolk, VAAn uncommanded flap retraction for reasons that could not be determined, as a postaccident examination of the flap system did not reveal evidence of any preaccident anomalies.NTSB WPR13LA270Accident · No injuriesLimited investigationFinal reportAero Vodochody L39C · Reno, NVThe other pilot’s failure to see and avoid the airplane during an air race training session, which resulted in a midair collision.NTSB ERA12FA149Accident · 1 fatalField investigationFinal reportAero Vodochody L39C · Rainbow City, ALAn in-flight loss of control in instrument meteorological conditions.NTSB ERA11LA390Accident · Serious injuriesLimited investigationFinal reportAero Vodochody L39C · West Milford, NJThe pilot's excessive airspeed and failure to attain the proper landing point, which resulted in the airplane touching down too fast and too far down the short runway. Contributing to the accident was the pilot's failure to retract the flaps after landing,…NTSB MIA07FA060Accident · 1 fatalField investigationFinal reportAero Vodochody Aero. Works L-39C · Titusville, FLThe pilot’s failure to ensure sufficient altitude while maneuvering in close proximity to the ground during an airshow, which resulted in an impact with terrain.NTSB ATL03LA113Accident · 1 fatalLimited investigationFinal reportAero Vodochody Aero Works L39C · Gadsden, ALThe loss of engine power during takeoff due to foreign object damage, which resulted in an in-flight collision with terrain during forced landing. Factors were the pilot's inadequate preflight inspection of the airplane, his failure to secure the…NTSB NYC02LA038Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Wilmington, DEA ruptured oil line, which resulted in oil spraying onto the APU exhaust and a subsequent fire.NTSB FTW01FA063Accident · 2 fatalField investigationFinal reportAero Vodochody L-39C · Pecan Island, LAthe pilot's failure to maintain altitude/clearance from terrain while performing low level aerobatics. A factor was fatigue.NTSB DEN01FA044Accident · 2 fatalField investigationFinal reportAero Vodochody Aero. Works L-39CT · Watkins, COThe pilot's failure to maintain aircraft control, and the subsequent inadvertent stall/mush. Factors were the pilot's diverted attention due to the failure of the rear canopy's acrylic transparency and the loss of communication with his back seat passenger,…NTSB LAX98LA298Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39 · Mesa, AZThe pilot's improper flare and his failure to follow the proper procedures for the aircraft and to maintain control of the aircraft.