Skip to content

NTSB investigations, 2022

28 cases where the sequence of events included Ground collision.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

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") = 2022 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '200' 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\") = 2022
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '200' 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") = 2022
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '200' 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 CEN23LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Brookshire, TXThe P51 pilot’s failure to see and avoid the PA46 during taxi operations.Dec 27, 2022 · N282TX · 2 aircraft · Substantial damage NTSB WPR23LA100Accident · No injuriesClass 4 · LimitedFinal reportAeronca 65-CA · Deming, NMThe occupant’s improper throttle movement during the start procedure, which resulted in forward movement and loss of airplane control.Dec 15, 2022 · N29447 · Substantial damage NTSB CEN23LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Denton, TXThe pilot’s failure to maintain clearance from another airplane while taxing in the run-up area.Dec 15, 2022 · N221MF · 2 aircraft · Substantial damage NTSB WPR23LA072Accident · No injuriesClass 4 · LimitedFinal reportCessna 441 · Liberal, KSThe pilot’s inadequate preflight inspection, failure to set the parking brake, and his decision to exit the airplane with engines running to remove a wheel chock, resulting in the airplane’s unintended movement and subsequent collision with a hangar.Dec 13, 2022 · N253SB · Substantial damage NTSB CEN23LA023Accident · Minor injuriesClass 4 · LimitedFinal reportStephen J Hoffman MS-500 · Houston, TXThe pilot’s failure to secure the magneto switch before attempting to hand rotate the engine which resulted in an inadvertent engine start, a runaway airplane, and subsequent impact with parked airplanes. Contributing to the accident was the failure to…Oct 29, 2022 · N778MS · Substantial damage NTSB CEN23LA015Accident · No injuriesClass 4 · LimitedFinal reportBeech B-60 · Ardmore, OKThe pilot did not ensure adequate clearance from construction vehicles during taxi.Oct 13, 2022 · N2889W · Substantial damage NTSB DCA22WA214Accident · No injuriesClass 5 · ForeignBoeing 777 · London, GabonSep 28, 2022 · HL-7782 · 2 aircraft · Substantial damage NTSB GAA22WA305Accident · No injuriesClass 5 · ForeignCessna C172 · Yao, JapanSep 22, 2022 · JA3969 · Substantial damage NTSB DCA22LA201Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Chicago, ILSouthwest Airlines flight crew’s misjudgment of the distance required to safely pass the American Airlines airplane.Sep 11, 2022 · N963WN · 2 aircraft · Minor damage NTSB DCA22WA206Incident · No injuriesClass 5 · ForeignBoeing 737 · Zurich, SwitzerlandSep 3, 2022 · TC-MKC NTSB WPR22LA325Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D1 · Hope, AKThe pilot’s failure to maintain clearance from a tree while taxiing.Aug 22, 2022 · N96095 · Substantial damage NTSB WPR22LA328Accident · No injuriesClass 4 · LimitedFinal reportFall Martin Super CUB · Stanley, IDThe pilot’s failure to maintain airplane control during takeoff with a crosswind.Aug 19, 2022 · N25MF · Substantial damage NTSB ERA22LA364Accident · Minor injuriesClass 4 · LimitedFinal reportAerotek Pitts Special S-1S · Erwinna, PAThe inability of both pilots to see and avoid the collision. Contributing to the accident was the pilot of the red airplane’s decision to utilize the converging runway for takeoff, contrary to the guidance published in the airport facility directory. Also…Aug 6, 2022 · N49310 · 2 aircraft · Substantial damage NTSB DCA22LA175Accident · No injuriesClass 4 · LimitedFinal reportBoeing 777 · Chicago, ILThe ground controller’s inappropriate routing of the B777 through a non-movement area, resulting in the airplane’s right wingtip contacting a light pole. Contributing to the accident was the lack of an appropriate display of taxiway BB2 as a restricted…Aug 6, 2022 · A7-BFH · Substantial damage NTSB CEN22LA346Accident · No injuriesClass 4 · LimitedFinal reportMeschler Gary R RV-4 · Oshkosh, WIThe failure of the pilot of N694V (RV-8) to maintain clearance from the preceding airplane, N79KM (RV-4), while taxiing for takeoff, which resulted in an on-ground collision.Jul 28, 2022 · N79KM · 2 aircraft · Substantial damage NTSB CEN22LA319Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-19B · Elbert, COThe pilot’s misidentification of the runway during the visual approach which resulted in an off runway landing and impact with a trailer.Jul 10, 2022 · N53JC · Substantial damage NTSB CEN22LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Rogers, ARThe pilot’s failure to establish a stabilize approach criteria during low-level maneuvering to the runway, which resulted in a hard landing and contact with a hay bale.Jul 9, 2022 · N83552 · Substantial damage NTSB DCA22LA135AccidentClass 4 · LimitedFinal reportAirbus A330 · New York, NYThe ITA Airways flightcrew’s misperception of the distance to maintain separation and safely pass the stopped Air France airplane.Jun 18, 2022 · EI-EJL · 2 aircraft · Minor damage NTSB WPR22LA201Accident · No injuriesClass 4 · LimitedFinal reportBombardier BD100 1A10 · Hawthorne, CAThe multi-engine pilot's failure to maintain clearance from another airplane during taxi.Jun 7, 2022 · N694PD · 2 aircraft · Minor damage NTSB ERA22LA252Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Daytona Beach, FLPilot’s failure to maintain clearance from a forklift while taxiing.Apr 26, 2022 · N32042 · Substantial damage NTSB CEN22LA165Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Calhan, COThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.Apr 3, 2022 · N9119W · Substantial damage NTSB CEN22LA149Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Grapevine, TXThe failure of the pilot of the second aircraft to maintain a safe distance from the lead airplane while taxiing, which resulted in a ground collision.Mar 18, 2022 · N78SA · 2 aircraft · Substantial damage NTSB GAA22WA108Accident · Minor injuriesClass 5 · ForeignPiper PA23 · Treasure Cay, BahamasFeb 20, 2022 · N62670 · Destroyed NTSB ERA22LA119Accident · No injuriesClass 4 · LimitedFinal reportGreat Lakes 2T-1A-2 · Naples, FLThe biplane pilot’s inadequate visual lookout, which resulted in an on-ground collision with another airplane while taxiing.Feb 11, 2022 · N87G · 2 aircraft · Minor damage NTSB DCA22WA222IncidentClass 4 · ForeignBoeing 737 · Ajuba, NigeriaFeb 3, 2022 · 5N-MJQ · Substantial damage NTSB ERA22LA115Accident · No injuriesClass 3 · LimitedFinal reportPilatus PC-12/47E · Ronkonkoma, NYThe pilot’s failure to properly position the power control lever before starting the engine as required per the checklist. Contributing to the accident were the ice on the ramp and the pilot’s failure to secure the engine using the condition lever.Feb 2, 2022 · N357JK · Substantial damage NTSB GAA22WA075Accident · 1 fatalClass 5 · ForeignPiper PA-25-260 · Uchoa, BrazilJan 15, 2022 · PR-SOD · Minor damage NTSB ERA22LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Knoxville, TNThe pilot of the Cessna 150’s failure to avoid the taxiing Cessna 172.Jan 8, 2022 · N1308U · 2 aircraft · Substantial damage