Fatal NTSB investigations: Allison 250 series
13 cases on aircraft whose registry engine model is Allison 250 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
| 1978 | 1 |
|---|---|
| 1986 | 1 |
| 1996 | 2 |
| 1998 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2020 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03014', '03019'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03014', '03019'))
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 WPR20LA224Accident · 1 fatalClass 3 · LimitedFinal reportHiller UH 12D · Mehama, ORAn in-flight separation of a tail rotor blade due to fatigue cracking and overstress, which resulted in a loss of directional control and subsequent ground impact.NTSB CEN13WA156Accident · 5 fatalForeign investigationCessna P210N · Charloeri, BelgiumOn February 9, 2013, about 0840 hours universal coordinated time, a Cessna P210N, United States registration N240PW, impacted terrain after takeoff from the Brussels South -- Charleroi Airport (EBCI), Charleroi, Belgium. The intended destination was Lyon,…NTSB ERA12FA527Accident · 1 fatalField investigationFinal reportBell 407 · Abingdon, VAThe pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…NTSB WPR10FA440Accident · 3 fatalField investigationFinal reportHiller UH 12E · Kamiah, IDIn-flight impact of a passenger's metal clipboard with the helicopter’s tail rotor, which resulted in destruction of the tail rotor and subsequent loss of control of the helicopter. The original location of the clipboard and how it became free could not be…NTSB WPR09LA069Accident · 1 fatalLimited investigationFinal reportHughes 369 · Honiara, Solomon IslandsThe pilot's failure to remove the tail rotor pedal lock before attempting flight, resulting in a loss of control.NTSB IAD05LA080Accident · 2 fatalLimited investigationFinal reportNavickas Load Runner 2000 · Hammonton, NJThe pilot's inadequate in-flight decision, which resulted in fuel exhaustion and subsequent loss of engine power. A factor was the wooded area, into which, the pilot had to autorotate.NTSB NYC03FA095Accident · 1 fatalField investigationFinal reportBeech A36 · Farmingdale, NJThe pilot's delayed decision to refuel, which resulted in fuel exhaustion and the subsequent loss of engine power.NTSB IAD01FA066Accident · 1 fatalField investigationFinal reportHughes 369A · Perry, WVThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain terrain clearance. A contributing factor was mountainous terrain.NTSB CHI98FA313Accident · 1 fatalField investigationFinal reportHiller FH-1100 · Dewitt, MIThe rotor failure/malfunction due to debonding of the tail rotor blade. Also causal was the inadequate maintenance inspection of the aircraft by the company and the improper maintenance procedure by other maintenance personnel.NTSB SEA97TA023Accident · 1 fatalFinal reportBell 47G-3B-1 · Fillmore, UTinadequate procedure and inadequate monitoring by the pilot, the operator, and/or other personnel, which allowed one of three external cables to the seed bucket to become entangled with the right skid of the helicopter, resulting in an imbalance and loss of…NTSB MIA96LA210Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Adel, GAthe pilot's misjudgment of clearance between the helicopter and the antenna. A factor relating to the accident was the pilot's use of a drug (medication) that had sedative effects.NTSB SEA86FA039Accident · 1 fatalField investigationFinal reportHiller-Soloy UH-12E · Horton, ORThe fork connecting the rotorcraft's blue blade to the main rotor hub separated after a long term fatigue crack had spread through more than 60% of the fork circumference. The operator failed to carry out the appropriate inspection of the fork unit as…NTSB SEA78FYK06Accident · 1 fatalClosedHiller UH-12E · Reedsport, OR