NTSB investigations, 2019, Outside the U.S.
9 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 6 |
| 2011 | 9 |
| 2012 | 8 |
| 2013 | 11 |
| 2014 | 4 |
| 2015 | 6 |
| 2016 | 23 |
| 2017 | 22 |
| 2018 | 23 |
| 2019 | 9 |
| 2020 | 14 |
| 2021 | 12 |
| 2022 | 20 |
| 2023 | 18 |
| 2024 | 27 |
| 2025 | 15 |
| 2026 | 14 |
Latest cases
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 year(c.\"eventDate\") = 2019
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' 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") = 2019 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' 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 DCA19WA177Incident · No injuriesForeign investigationBoeing 737 · Kiev, UkraineThe NBAAI of Ukraine has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the NBAAI's investigation under the provisions of ICAO Annex 13 as…NTSB GAA19WA478Accident · No injuriesForeign investigationBeech C90 · Bucaramanga, ColombiaNTSB DCA19WA176Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as State of…NTSB DCA19WA180Incident · No injuriesForeign investigationBoeing 737 · Mangalore, IndiaThe AAIB of India has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on June 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as State of…NTSB DCA19WA163Accident · No injuriesForeign investigationCasa C212 · Kuinga, KenyaThe Ministry of Transport of the Republic of Kenya has notified the NTSB of an accident involving a CASA 212, which occurred on June 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under the provisions of ICAO…NTSB DCA19WA145Incident · No injuriesForeign investigationBoeing 737 · Bogota, ColombiaThe GRIAA of Colombia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on April 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the GRIAA's investigation under the provisions of ICAO Annex 13 as…NTSB DCA19WA131Incident · No injuriesForeign investigationBoeing 737 · Jogyakarta, IndonesiaThe KNKT of Indonesia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation under the provisions of ICAO Annex 13 as…NTSB DCA19WA108Incident · No injuriesForeign investigationBoeing 767 · Halifax, CanadaThe government of Canada has notified the NTSB of an accident involving a BOEING 767 airplane that occurred on March 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB DCA19WA087Incident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a Boeing 737, which occurred on February 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…