NTSB defining event · CICTT: Ground Handling
CICTT occurrence categories (PDF)CICTT phases of flight (PDF)
- Defining event in
- 39 cases
- In the sequence of
- 44 cases
- Fatal cases
- 1
- NTSB code
- 082
NTSB has coded findings and defining events since 2008. Earlier cases used its older occurrence and cause codes, so they aren’t counted here.
When and where
In green, cases where it was the defining event; in gray, cases where it came elsewhere in the sequence. The map shows the cases where it was the defining event. Events are coded with the final report, so the latest years are incomplete.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2021 | 3 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 1 |
| 2025 | 3 |
| 2026 | 4 |
Where
Open the mapQuery with SQL
duckdb -csv -c "SELECT year(c.\"eventDate\") AS year, count(DISTINCT e.case_mkey) AS cases,
count(DISTINCT e.case_mkey) FILTER (WHERE e.\"isDefiningEvent\") AS defining
FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = e.case_mkey
WHERE e.\"tier2Number\" = '082' AND e.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")
GROUP BY 1
ORDER BY 1"Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT year(c."eventDate") AS year, count(DISTINCT e.case_mkey) AS cases, count(DISTINCT e.case_mkey) FILTER (WHERE e."isDefiningEvent") AS defining FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = e.case_mkey WHERE e."tier2Number" = '082' AND e.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent") GROUP BY 1 ORDER BY 1
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.
In these cases
Aircraft matched to the registry by N-number and date.
Query with SQL
duckdb -csv -c "WITH defining AS (SELECT * FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"tier2Number\" = '082' AND \"isDefiningEvent\")
SELECT * FROM (
SELECT 'Phase of flight' AS kind, e.\"tier1Number\" AS code, max(e.\"eventTier1Name\") AS name, count(DISTINCT e.case_mkey) AS cases
FROM defining e
GROUP BY ALL
UNION ALL
SELECT 'Finding in the probable cause', left(f.\"findingCode\", 8), max(f.\"tier4Name\"), count(DISTINCT f.case_mkey)
FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f ON f.case_mkey = e.case_mkey AND f.aircrafts_position = e.aircrafts_position AND f.\"inProbableCause\"
WHERE f.\"findingCode\" GLOB '[0-9][0-9]*'
GROUP BY ALL
UNION ALL
SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT e.case_mkey)
FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = e.case_mkey AND a.position = e.aircrafts_position
LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = a.aircraft_model_code
WHERE a.aircraft_model_code IS NOT NULL
GROUP BY ALL
)
QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
ORDER BY kind, cases DESC"Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
WITH defining AS (SELECT * FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "tier2Number" = '082' AND "isDefiningEvent")
SELECT * FROM (
SELECT 'Phase of flight' AS kind, e."tier1Number" AS code, max(e."eventTier1Name") AS name, count(DISTINCT e.case_mkey) AS cases
FROM defining e
GROUP BY ALL
UNION ALL
SELECT 'Finding in the probable cause', left(f."findingCode", 8), max(f."tier4Name"), count(DISTINCT f.case_mkey)
FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f ON f.case_mkey = e.case_mkey AND f.aircrafts_position = e.aircrafts_position AND f."inProbableCause"
WHERE f."findingCode" GLOB '[0-9][0-9]*'
GROUP BY ALL
UNION ALL
SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT e.case_mkey)
FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = e.case_mkey AND a.position = e.aircrafts_position
LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = a.aircraft_model_code
WHERE a.aircraft_model_code IS NOT NULL
GROUP BY ALL
)
QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
ORDER BY kind, cases DESCRun 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.
Newest cases · 39
NTSB DCA26WA367Incident · No injuriesClass 5 · ForeignAirbus A321-271NX · Guayaquil, EcuadorNTSB DCA26LA329Accident · Serious injuriesClass 4 · LimitedInvestigation openBoeing 777 · Boston, MANTSB DCA26LA164Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8 · Dulles, VAThe tug drivers improper positioning of the airplane during pushback, which resulted in the airplane’s jet blast impacting an active gate area during taxi and the subsequent injury to a maintenance technician. Contributing to the accident was the captain’s…NTSB WPR26LA122Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182M · Flagstaff, AZMaintenance personnel’s decision to conduct an engine run at takeoff power in front of an active taxiway, and their failure to notify ATC, which resulted in the accident pilot’s loss of control during taxi due to an encounter with a jet blast.NTSB GAA26WA032Accident · No injuriesClass 5 · ForeignPilatus PC24 · Lago Sul, BrazilNTSB DCA25LA268Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A319-131 · Santa Barbara, CAThe ramp worker’s premature entry into the jet blast hazard area of an operating engine due to his failure to maintain situational awareness and his misinterpretation of the marshaller’s hand signals.NTSB CEN25LA122Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 208B · Dallas, TXOn March 14, 2025, about 0738 central daylight time, a Cessna 208B airplane, N9471B, sustained substantial damage when it was involved in an accident at the Dallas-Fort Worth International Airport (DFW), Dallas, Texas. The pilot was not injured. The airplane…NTSB CEN24LA117Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · San Marcos, TXThe pilot’s failure to maintain sufficient clearance from a large multi-engine airplane during taxi operations.NTSB ERA24LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Miami, FLThe business jet flight crew’s failure to appropriately position their airplane to mitigate the impact of their extended duration, high-power engine run, and their failure to adequately communicate these factors to air traffic control, which resulted in the…NTSB DCA23WA460Incident · Serious injuriesClass 5 · ForeignBoeing 787 · Melbourne, Australia
See all 39 casesQuery 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 c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '082') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '082') 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.