NTSB defining event · CICTT: Ground Handling
CICTT occurrence categories (PDF)CICTT phases of flight (PDF)
- Defining event in
- 51 cases
- In the sequence of
- 61 cases
- Fatal cases
- 21
- NTSB code
- 081
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 | 7 |
|---|---|
| 2009 | 4 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 7 |
| 2025 | 3 |
| 2026 | 1 |
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\" = '081' 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" = '081' 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\" = '081' 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" = '081' 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 · 51
NTSB CEN25LA316Accident · Serious injuriesClass 4 · LimitedFinal reportXag P100 PRO · Depew, IAThe pilot’s failure to maintain clearance from the unmanned aircraft system during takeoff.NTSB CEN25LA243Accident · Serious injuriesClass 4 · LimitedFinal reportStinson 108 · Seguin, TXThe pilot’s failure to turn off the magneto switch before repositioning the propeller by hand which resulted in an inadvertent engine start.NTSB GAA25WA171Accident · 1 fatalClass 5 · ForeignCessna 188 · Trinidad Casanare, ColombiaNTSB CEN25LA028Accident · 1 fatalClass 3 · LimitedPreliminary reportCessna 182Q · Rose Hill, KSOn October 26, 2024, about 1440 central daylight time, a Cessna 182Q airplane was not damaged when it was involved in an accident near Rose Hill, Kansas. The pilot was not injured, and a passenger sustained fatal injuries. The airplane was operated as a Title…NTSB ERA25LA032Accident · Serious injuriesClass 4 · LimitedFinal reportAero SP Z O O AT-4 LSA · South Charleston, WVThe pedestrian’s inadequate visual lookout while walking next to an active runway, which resulted in the airplane striking him during taxi.NTSB CEN24LA197Accident · Serious injuriesClass 4 · LimitedFinal reportCessna U206 · Butler, MOThe jumper’s unintentional deployment of his emergency parachute and subsequent impact with the airplane’s horizontal stabilizer.NTSB ERA24LA149Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA28 · Apopka, FLThe pilot and the landscape worker’s inadequate visual lookout, which resulted in a collision.NTSB WPR24LA099Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Dallesport, WAThe pilot’s failure to disengage the ignition prior to moving the propeller by hand resulting in the inadvertent starting of the engine.NTSB WPR23LA259Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A-1B · Las Vegas, NVThe pilot’s unsafe inflight operation of the airplane and failure to maintain clearance from a person on the ground, which resulted in a serious injury.NTSB WPR23LA207Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Kingman, AZThe failure of the passenger to adequately maintain a safe distance from the airplane’s propeller and the determination to let the passenger exit the airplane with the engine running.
See all 51 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\" = '081') 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" = '081') 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.