NTSB investigations: Beech C90

6 cases on aircraft the registry lists as Beech C90, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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

19902026

NTSB investigations: Beech C90 per year, 1990–2026: 6 cases
1990	1
1992	1
1998	1
2001	2
2007	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152913', '1153928') 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" = 353)) 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.aircraft_model_code IN ('1152913', '1153928')
      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\" = 353))
  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.aircraft_model_code IN ('1152913', '1153928')
    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" = 353))
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 NYC07LA245Accident · No injuriesLimited investigationFinal reportBeech C-90 · Bloomingdale, GAA loss of engine power due to fuel exhaustion as a result of the pilot's improper preflight planning and preparation. Contributing to the accident was the pilot's reliance on inaccurate fuel gauges.Sep 15, 2007 · N515KJ · Substantial damage NTSB FTW02LA008Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Dallas, TXthe pilot's failure to refuel the airplane, which resulted in fuel exhaustion and subsequent loss of dual engine power while on approach.Oct 9, 2001 · N690JP · Substantial damage NTSB NYC01FA127Accident · Serious injuriesField investigationFinal reportBeech C90 · Islip, NYThe pilot’s failure to activate the fuel transfer pumps in accordance with the check list, which resulted in fuel exhaustion.May 18, 2001 · N270TC · Substantial damage NTSB IAD98FA027Accident · 2 fatalField investigationFinal reportBeech C-90 · Newton, WVThe pilot inadequate management of the fuel system which resulted in fuel starvation to both engines. Factors in the accident were the pilot's concern about maintenance being completed prior to executing a scheduled flight later in the day, and operating the…Feb 16, 1998 · N5WU · Destroyed NTSB CHI92LA237Accident · No injuriesLimited investigationFinal reportBeech C90 · Pontiac, MIThe pilot's not understanding the fuel system, and his subsequent inadvertent discontinuance of fuel to both engines.Aug 6, 1992 · N90RG · Substantial damage NTSB FTW90FA069Accident · 2 fatalField investigationFinal reportBeech C-90 · Burlington, NCThe double engine power loss due to fuel starvation, the pilot's failure to follow procedures and directives by not engaging the right fuel transfer pump, and the inadvertent stall during the forced landing approach. A factor was the pilot's failure to refuel…Feb 13, 1990 · N110LT · Destroyed