NTSB investigations: Allison 250-C20 series, NY

9 cases on aircraft whose registry engine model is Allison 250-C20 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Allison 250-C20 series, NY per year, 1982–2026: 9 cases
1982	1
1986	1
1992	1
2000	1
2001	1
2006	1
2018	1
2020	1
2021	1

Where

Open the map

Latest cases

Query with SQL

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" = 'NY' 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')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'NY' 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'))
  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" = 'NY' 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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA21LA262Accident · Serious injuriesClass 3 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Swan Lake, NYThe pilot's failure to maintain adequate clearance from the power transmission tower structure during powerline maintenance work, which resulted in the helicopter's main rotor striking the lifeline support bracket for the tower catwalk and the subsequent loss…Jun 18, 2021 · N371EE · Substantial damage NTSB ERA21LA028Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Point Lookout, NYThe pilot’s decision to depart on a visual flight rules flight, and to continue that flight into forecasted and deteriorating instrument meteorological conditions (IMC) in a helicopter that was not equipped for flight in IMC, which resulted in the pilot’s…Oct 21, 2020 · N716VL · Substantial damage NTSB ERA19FA035Accident · 2 fatalField investigationFinal reportAerospatiale AS 355F2 · Beekmantown, NYThe pilot's failure to keep the helicopter clear of a utility pole while hovering with a tailwind, which resulted in a dynamic rollover into active power lines.Oct 30, 2018 · N372CA · Destroyed NTSB NYC06LA122Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Mattituck, NYA loss of engine power due to undetermined reasons.May 28, 2006 · N9244F · Substantial damage NTSB NYC01LA179Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Niagara Falls, NYThe right skid getting snagged on the helicopter-dolly resulting in dynamic rollover.Jul 19, 2001 · N577DB · Substantial damage NTSB IAD00LA015Accident · No injuriesLimited investigationFinal reportBell 206A · Brutus, NYWas the pilot's failure to maintain directional control after encountering a loss of tail rotor effectiveness.Jan 5, 2000 · N206GR · Substantial damage NTSB NYC92T#A01Accident · No injuriesClass 3Final reportMBB BO-105CBS · Brooklyn, NYJul 27, 1992 · N729RJ · Substantial damage NTSB NYC87LA030Accident · Serious injuriesLimited investigationFinal reportBell 206B · Staten Island, NYThe on-demand cargo flight encountered a bird strike enroute from new jersey to jamaica, new york. The pilot received serious injury to the eye and checkbone but was able to accomplish an emergency landing in a parking lot without further damage or injury.Nov 6, 1986 · N83086 · Substantial damage NTSB NYC82FA230Accident · 1 fatalField investigationFinal reportBell 222 · New York, NYThe helicopter (hel) was being loaded with the engines running. The flt crew were at the ctls when the acdnt occurred. Initially, 4 paxs were escorted to the hel by a customer svc agent. As the 4 boarded, the agent retrieved their carry on baggage. Aft they…Sep 22, 1982 · N2772H · Minor damage