Skip to content

NTSB investigations: Allison 250 SER 400HP

231 cases on aircraft whose registry engine model is Allison 250 SER 400HP. 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, newest first

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03013', '03012')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('03013', '03012'))
  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 ('03013', '03012'))
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 FTW78FA025Accident · 1 fatalClosedBell 206B · Palacids, TXJan 25, 1978 · N90024 · Destroyed NTSB SEA78DYK04Accident · Minor injuriesClosedHiller Acft FH1100 · Walton, ORDec 22, 1977 · N92484 · Destroyed NTSB SEA78DYP03Accident · No injuriesClosedHughes 369D · Spokane, WAOct 12, 1977 · N8601F · Substantial damage NTSB ANC77FA086Accident · Minor injuriesClosedHughes 369HS · Cantwell, AKSep 2, 1977 · N9138F · Substantial damage NTSB MIA77FKT69Accident · Minor injuriesClosedBell 206B · Ft Myers, FLAug 27, 1977 · N90324 · Substantial damage NTSB OAK77FA038Accident · Minor injuriesClosedHughes 369HS · Mt Darwin, CAJul 4, 1977 · N9167F · Substantial damage NTSB FTW77FA060Accident · Minor injuriesClosedBolkow BO-105 · Intracstl Cy, LAJun 7, 1977 · N90754 · Substantial damage NTSB FTW77DRD12Accident · No injuriesClosedBell 206B · Leeville, LAApr 22, 1977 · N65AL · Minor damage NTSB FTW77FA044Accident · 1 fatalClosedBell 206B · Intracoastal C, LAMar 17, 1977 · N90071 · Destroyed NTSB MIA77FA032Accident · Serious injuriesClosedBell 206B · Atlanta, GAFeb 18, 1977 · N14824 · Substantial damage NTSB OAK76FJA25Accident · Minor injuriesClosedHughes 369 · Haena Kauai, HISep 24, 1976 · N9261F · Substantial damage NTSB ANC76AA123Accident · 1 fatalClosedHiller Acft UH12EJ · Sheep Mountain, AKAug 15, 1976 · N47078 · Destroyed NTSB ANC76AA109Accident · Serious injuriesClosedHughes 369HS · Juneau, AKJul 9, 1976 · N55ST · Substantial damage NTSB OAK76AP060Accident · 3 fatalClosedBell 206B · Carson City, NVJul 5, 1976 · N600SW · Substantial damage NTSB OAK76AP057Accident · 2 fatalClosedBell 206B · Bishop, CAJun 22, 1976 · N7941S · Destroyed NTSB FTW76DPM26Accident · No injuriesClosedHughes 369HS · Vinita, OKJun 7, 1976 · N500PA · Substantial damage NTSB ANC76AA094Accident · No injuriesClosedBell 206B · Coldfoot, AKJun 3, 1976 · N90188 · Substantial damage NTSB SEA76FTA09Accident · No injuriesClosedBell 206B · Miles City, MTDec 14, 1975 · N59495 · Substantial damage NTSB OAK76FVG27Accident · No injuriesClosedBell 206B · Alder Springs, CAOct 4, 1975 · N59549 · Substantial damage NTSB LAX76AL015Accident · Minor injuriesClosedBell 206B · Van Nuys, CAAug 26, 1975 · N59560 · Substantial damage NTSB ANC76AA011Accident · Minor injuriesClosedHughes 369HS · Deadhorse, AKJul 21, 1975 · N717ST · Substantial damage NTSB SEA7LFYE02Accident · Minor injuriesClosedHughes 369HS · Elma, WAJul 2, 1975 · N82AL · Substantial damage NTSB ANC75AA070Accident · No injuriesClosedBell 206B · Allison Lake, AKMar 25, 1975 · N58012 · Substantial damage NTSB LAX75DUJ55Accident · No injuriesClosedBell 206B · Glendale, AZJan 14, 1975 · N59383 · Substantial damage NTSB CHI75FEI20Accident · Minor injuriesClosedHughes 369HS · Bosworth, OHOct 7, 1974 · N9204F · Substantial damage NTSB ANC74FAA19Accident · Minor injuriesClosedHiller Acft FH1100 · Fairbanks, AKOct 23, 1973 · N369FH · Substantial damage NTSB OAK73FJA09Accident · No injuriesClosedBell 206A · Kaimuki, HINov 29, 1972 · N1404W · Substantial damage NTSB NYC73AN069Accident · No injuriesClosedBell 206 · Port Washngton, NYNov 20, 1972 · N7941S · Substantial damage NTSB SEA72DYE38Accident · Minor injuriesClosedHughes 500 · Longmire, WAJun 30, 1972 · N9068F · Substantial damage NTSB LAX70D0198Accident · No injuriesClosedBell 47G3B1 · Parker, AZNov 5, 1969 · N614 · Substantial damage NTSB OAK70F0003Accident · Minor injuriesClosedHiller FH1100 · Lincoln, CAApr 22, 1969 · N436F · Substantial damage