NTSB investigations, 2018

8 cases where the sequence of events included Air traffic event.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

NTSB investigations, 2018 per year, 2008–2026: 115 cases
2008	6
2009	5
2010	7
2011	9
2012	5
2013	3
2014	4
2015	4
2016	5
2017	5
2018	8
2019	4
2020	2
2021	4
2022	6
2023	9
2024	8
2025	6
2026	15

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 year(c."eventDate") = 2018 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '100' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 year(c.\"eventDate\") = 2018
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '100' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 year(c."eventDate") = 2018
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '100' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
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 DCA19WA057Incident · No injuriesForeign investigationBoeing 747-428 · Delhi Airspace, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on December 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…Dec 21, 2018 · N919CA · No damage NTSB DCA19WA071Incident · No injuriesForeign investigationBoeing 747 · Kolkata, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…Oct 16, 2018 · N578UP · No damage NTSB OPS18IA014IncidentClass 3 · IncidentFinal reportEmbraer EMB145 · Springfield, MOThe local controller failing to follow established facility directives and issuing a clearance for takeoff from a runway not under his control.Jun 27, 2018 · N655AE · No damage NTSB DCA18WA161Incident · No injuriesForeign investigationBoeing 737 · Perth, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…Apr 28, 2018 · VH-XZM · 2 aircraft · No damage NTSB DCA18WA138Incident · No injuriesForeign investigationBoeing 737 · Brasilia City, BrazilThe government of Brazil has notified the NTSB of a serious incident involving a EMBRAER EMB110 airplane that occurred on April 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…Apr 9, 2018 · PR-GTN · 2 aircraft · No damage NTSB DCA18WA156Incident · No injuriesForeign investigationBoeing 767 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 767 airplane that occurred on March 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Mar 27, 2018 · C-GHLV · No damage NTSB ANC18LA030Accident · No injuriesLimited investigationFinal reportChampion 7GC · Anchorage, AKThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a loss of control and failure of the main landing gear. Contributing to the accident was the pilot's self-induced pressure to land.Mar 26, 2018 · N4844E · Substantial damage NTSB DCA18WA088Incident · No injuriesForeign investigationBoeing 757 23A · Tel Aviv, IsraelThe Israel's Ministry of Transport has notified the NTSB of an incident involving a Boeing 757, which occurred on January 30, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of…Jan 30, 2018 · N919FD · No damage