NTSB investigations: Allison 250-C20 series
372 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.
Cases, newest first
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 ('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."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" 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 FTW84LA270Accident · Minor injuriesLimited investigationFinal reportBell 206B · South PeltoWhile cruising at 550 ft above the gulf of Mexico, the plt noted hi tot indications, followed by loss of N1 RPM & eng failure. An autorotation was initiated which terminated in a hard landing in 5 ft waves. One emergency float separated during the landing &…NTSB LAX83FA400Accident · Minor injuriesField investigationFinal reportBell 206-B · Battle Mountain, NVThe helicopter lost power during takeoff,touched down on the left skid,bounced and rolled over. The flt had originated at 1315 at a local field and proceeded to pick up a passenger at another location. The acft had just landed, picked up the passenger and was…NTSB ANC83FA144Accident · No injuriesField investigationFinal reportBell 206L-1 · Bettles, AKAccording to the plt, the low fuel warning light illuminated when the fuel gage was indicating 200 lbs. He reported he could see the arpt lights & elected to continue the flt. After arriving, he terminated his apch to a 30 to 50 ft hover with no forward…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…NTSB ANC82DA062Accident · 1 fatalFinal reportHughes 369D · Near Bornite, AKTwo workers were transported to a mine drilling site where the helicopter was landed on a man-made heli-pad. The heli-pad was an area about 50 ft long and 12 ft wide that had been cut into the side of a rocky hill. After off-loading the workers, the pilot…NTSB FTW82DA028Accident · No injuriesClosedBell 206B · Gulf Of Mexico (Atlantic Ocean)NTSB LAX82DXQ02Accident · No injuriesClosedBell 206B · Ely, NVNTSB DEN81FA062Accident · Minor injuriesClosedHughes 369D · Afton, WYNTSB ANC81FA064Accident · Minor injuriesClosedHughes 369D · Tanacross, AKNTSB DEN81FA022Accident · No injuriesClosedBell 206A · Evanston, WYNTSB CHI80DEM44Accident · No injuriesClosedHughes 500D · Manistee, MINTSB FTW80FA081Accident · No injuriesClosedBell 206B · Intercstl City, LANTSB SEA80FYM12Accident · No injuriesClosedHiller Acft UH-12E · Willamina, ORNTSB FTW80FRD08Accident · No injuriesClosedHughes 369D · Abbeville, LANTSB SEA79FYK05Accident · No injuriesClosedHiller Acft UH-12E · Springfield, ORNTSB OAK79DVG13Accident · No injuriesClosedHughes 369C · Montague, CANTSB SEA78FYE11Accident · No injuriesClosedHiller Acft UH-12E · Montesano, WANTSB MIA76FKT32Accident · Serious injuriesClosedBell 206B · Delray Beach, FLNTSB ANC76AA024Accident · No injuriesClosedHughes 369HS · Nome, AKNTSB MIA75DKG90Accident · No injuriesClosedBell 206A · Blairsville, GANTSB MKC74DCJ19Accident · No injuriesClosedBell 206A · North Platte, NENTSB ANC74AA013Accident · Serious injuriesClosedHughes 369HS · Ketchikan, AK