Fatal NTSB investigations

4 cases where the first occurrence was “Near collision between aircraft”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Fatal NTSB investigations per year, 1982–2026: 4 cases
1982	2
1986	1
2006	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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 280) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 280)
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 280)
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 LAX06FA099Accident · 1 fatalField investigationFinal reportBeechcraft F33A · Buckeye, AZThe student pilot's failure to maintain aircraft control for undetermined reasons.Feb 1, 2006 · N1563A · Destroyed NTSB SEA86FA052Accident · 1 fatalField investigationFinal reportCessna 195 · Black Diamond, WARadar track shows C195 plt was descending into congested airspace at about 192 mph, above max structural cruise speed of 178 mph, less than 1 min from traffic pattern entry. Radar data and witness confirm a second acft in proximity, engaged in aerobatics.…Feb 1, 1986 · N4339N · Destroyed NTSB ATL82FIG09Accident · 2 fatalFinal reportBellanca 7GCBC · Woodbine, MDAfter taking off from runway 21, the pilot made a left turn-out then reentered a downwind for runway 03. At about the same time, a Cessna 150 was departing from runway 21 and a glider entered the pattern to land on runway 03. Two witnesses observed the…Jun 18, 1982 · N5153X · Destroyed NTSB SEA82FA052Accident · 1 fatalField investigationFinal reportCessna A152 · Bremerton, WAThe pilot took off downwind and against traffic in marginal weather conditions. No flight plan was filed and there was no record of a weather briefing. During departure, a near-miss occurred between N761QZ and a light twin-engine aircraft on an instrument…Apr 11, 1982 · N761QZ · Destroyed