NTSB investigations: Allison V1710 series
10 cases on aircraft whose registry engine model is Allison V1710 series. 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
| 1969 | 1 |
|---|---|
| 1981 | 1 |
| 1984 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2022 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03040', '03001'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03040', '03001'))
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 CEN23MA034Accident · 6 fatalClass 1 · MajorFinal reportBoeing B17 · Dallas, TXthe air boss’s and air show event organizer’s lack of an adequate, prebriefed aircraft separation plan for the air show performance, relying instead on the air boss’s real-time deconfliction directives and the see-and-avoid strategy for collision avoidance,…NTSB ERA15LA039Accident · No injuriesLimited investigationFinal reportCurtiss Wright P 40B · New Smyrna Beach, FLThe pilot’s failure to maintain directional control while landing with a crosswind, which resulted in a ground loop and a subsequent runway excursion.NTSB CEN12LA111Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright P40M · Batavia, OHA loss of engine power due to failure of the engine oil cooler and subsequent oil starvation to the engine.NTSB ERA09LA330Accident · No injuriesLimited investigationFinal reportYakovlev/Day YAK-11 · Culpeper, VAThe pilot’s failure to maintain directional control during landing.NTSB CHI07FA243Accident · 1 fatalField investigationFinal reportBeck P-51A · Oshkosh, WIThe P-51A pilot's inadequate visual lookout and his failure to maintain clearance from the P-51D. Contributing factors to the accident included the restricted forward visibility of the P-51A, the air race team representative's inadequate flight brief, the…NTSB DFW05CA107Accident · No injuriesData collectionFinal reportBell P39 · Fredericksburg, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the reported partial failure of the left wheel brake.NTSB MIA01LA171Accident · No injuriesLimited investigationFinal reportLockheed P-38L-5LD · Greenwood, MSthe failure and uncontained separation of supercharger impeller blades for undetermined reasons during normal descent, resulting in a punctured fuel line and the subsequent in-flight engine fire and emergency descent and forced landing to a farm field.NTSB LAX84LA441Accident · No injuriesLimited investigationFinal reportBell P-63C-5-BE · Madera, CAThe plts of a Bell P-63 (king cobra), N62822 & a north American P-51 (mustang), N65206, were participating in an air- show when the acft collided during landing. An investigation revealed the P-63 plt had made a 360 overhead pattern before landing. At about…NTSB DEN81FTM15Accident · 1 fatalClosedLockheed P-38 · Salt Lake City, UTNTSB MKC70F0092Accident · Minor injuriesClosedBell P-63C5 · Crystal, MN