NTSB investigations: Allison 250-C20 series, CA
6 cases on aircraft whose registry engine model is Allison 250-C20 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1987 | 1 |
|---|---|
| 1992 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2006 | 1 |
Where
Latest 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03020')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03020')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 LAX06LA161Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Fallbrook, CAFailure of the engine to transmission drive shaft forward coupling due to overheating from lack of lubrication. The cause of the lack of lubrication was a result of improper maintenance. A factor was the trees.NTSB LAX01IA262Incident · No injuriesIncident investigationFinal reportMdhi 520N · Los Angeles, CAthe excitation of the first bending mode natural frequency of the aft tube assembly that is installed through the rotating NOTAR fan drive system. Contributing factors to the incident included the operator's maintenance practice of hand-sanding the pitch…NTSB LAX01FA006Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas 369E · Kernville, CAThe pilot's improper storage of personal items and his inadequate preflight inspection, which resulted in the unlatching of the left rear cabin door during flight and allowing a plastic garment bag to blow out and strike the tail rotor.NTSB LAX00GA025Accident · 2 fatalFinal reportMcDonnell Douglas 500N · San Jose, CAThe pilot's in-flight loss of control due to the failure and separation of the forward thruster control cable telescoping sleeve ball swivel fitting, which resulted in a stuck thruster and the entry into an uncontrollable yaw/spin. Also causal was the…NTSB LAX93LA044Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlsbad, CAFailure of the overrunning clutch assembly bearing for undetermined reasons.NTSB LAX87FA173Accident · Serious injuriesField investigationFinal reportHughes 369E · Palm Desert, CAThe helicopter dscndd uncontrolled & crashed in a residential area. After the acdnt, the plt said he agreed to orbit the residence of his pax. At the aprx 135 deg point of a left orbit, he felt 'a bang & severe vibration in the tail.' The plt lost drctnl ctl…