Final NTSB investigations
32 cases where the defining event was Airport occurrence.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 2 |
| 2015 | 5 |
| 2016 | 4 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 2 |
Where
Open the mapLatest 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 c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '070')
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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '070') 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 ERA24LA131Accident · No injuriesClass 4 · LimitedFinal reportFairchild SA227-AT · Smyrna, TNThe airplane encountered a sink hole while taxiing.NTSB WPR24LA068Accident · No injuriesClass 3 · LimitedFinal reportCessna 421C · Carson City, NVAirport personnel’s failure to properly prioritize their response actions, including updating the airport’s automated weather observation system recording in a timely manner to notify incoming pilots of a runway closure, which resulted in an airplane striking…NTSB CEN22LA328Accident · No injuriesClass 4 · LimitedFinal reportEurocopter Deutschland EC 135 · Mount Vernon, ILThe inadequate securement of the cloth fire extinguisher cover, which resulted in it being blown off the fire extinguisher and ingested into the helicopter’s fenestron during the landing.NTSB ANC21LA030Accident · No injuriesClass 4 · LimitedFinal reportBeech C-99 · Chignik Lagoon, AKThe pilot’s failure to visually inspect the runway condition before landing, which resulted in a collision with an ice chunk and main landing gear separation during landing.NTSB CEN21LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna 182Q · Spearfish, SDThe snowplow driver’s failure to see the airplane which resulted in a collision with the airplane.NTSB DCA19CA192Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · SFO International Airport, CAthe ramp controller directing a Boeing 737 to hold in a location that was marked for a regional jet.NTSB GAA19CA346Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, TXThe passing pilot’s failure to maintain clearance from the airplane that he was attempting to pass during taxi operations. Contributing to the accident was the passing pilot's distraction due to looking at his on-board navigation device while attempting to…NTSB GAA19CA174Accident · No injuriesData collectionFinal reportPiper PA32R · Atmautluak, AKThe airplane's encounter with a snow-covered pothole during taxi.NTSB GAA17CA149Accident · No injuriesData collectionFinal reportPiper PA28 · Palm Coast, FLThe pilot’s failure to maintain clearance from the taxiway sign.NTSB GAA16CA417Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot's failure to maintain clearance from the building door, which resulted in substantial damage to the left wing.NTSB ERA16CA302Accident · No injuriesData collectionFinal reportBeech B200 · Burnsville, NCA collision with a bush during landing.NTSB GAA16CA119Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Everglades, FLThe pilot's failure to maintain adequate wing clearance while taxiing, which resulted in a collision with two unoccupied airplanes.NTSB GAA16LA056Accident · No injuriesLimited investigationFinal reportAirbus EC135 · Apple Valley, CAThe ingestion of a towel from an unsecured storage container at the landing site into the helicopter's fenestron during the landing.NTSB GAA16CA052Accident · No injuriesData collectionFinal reportCessna 172S · Alcoa, TNThe pilot's failure to identify the taxiway, which resulted in a runway excursion and impact with terrain while turning off the runway at night.NTSB GAA16CA034Accident · No injuriesData collectionFinal reportCessna 182R · Abilene, TXThe pilot's diverted attention while taxiing, which resulted in a collision with a fence post.NTSB GAA16CA012Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Kanab, UTThe pilot's failure to monitor the airplane's movement on the ground while programming the GPS, which resulted in a collision with a pole.NTSB GAA15CA254Accident · No injuriesData collectionFinal reportPiper PA 18-150 · LaBelle, FLThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over and impact with terrain.NTSB ERA13CA081Accident · No injuriesData collectionFinal reportBeech F90 · Knoxville, TNThe pilots’ decision to maneuver the airplane in close proximity to a hangar.NTSB WPR12CA073Accident · No injuriesData collectionFinal reportMcadam W E Christen Eagle II · Eureka, CAA collision with a deer while landing.NTSB WPR11CA347Accident · No injuriesData collectionFinal reportCessna 182B · Sandy, ORThe pilot's failure to maintain adequate clearance between the airplane and ground obstacles.NTSB DCA11FA052Accident · No injuriesField investigationFinal reportBoeing 737 · Greenville, MSThe failure of a utility pipe beneath the ramp surface, which caused a localized void in the soil and resulting reduction in the load bearing capability of the ramp.NTSB WPR11CA033Accident · No injuriesData collectionFinal reportMedway Raven · Benson, AZThe pilot's inadequate evaluation of the runway condition and failure to maintain directional control during takeoff.NTSB WPR10CA327Accident · No injuriesData collectionFinal reportCessna 172 · Cascade, IDThe pilot’s encounter with an unknown hole in the runway during the landing roll.NTSB CEN10CA195Accident · No injuriesData collectionFinal reportCessna 175 · Eveleth, MNThe pilot's selection of unsuitable terrain for landing.NTSB OPS10IA015Incident · No injuriesIncident investigationFinal reportCessna 208B · Phoenix, AZThe Cessna 208 pilot’s failure to identify the correct landing runway.NTSB WPR10CA050Accident · No injuriesData collectionFinal reportAeromot AMT-200(SU · Placerville, CAThe pilot's failure to maintain clearance from an obstacle during the landing rollout. Contributing to the accident was the presence of the brush in proximity to the runway.NTSB MIA08CA190Accident · No injuriesData collectionFinal reportCessna 310R · Lake Placid, NYThe pilot's failure to observe the ongoing construction to the closed runway while landing. Contributing to the accident was flight service's failure to brief the pilot of the closed runway.NTSB CHI08CA265Accident · No injuriesData collectionFinal reportPiper PA-28-161 · New Ulm, MNThe failure of airport personnel to correct a hazardous condition on the airport. A factor was the uncovered manhole.NTSB CHI08CA231Accident · No injuriesData collectionFinal reportWeatherly 201B · Creston, ILThe pilot's selection of the unsuitable terrain next to the runway to avoid the landing traffic. Contributing to the accident was the hill in the middle of the runway that blocked the pilot's view of the other traffic and the high vegetation near the runway.NTSB OPS08IA010Incident · No injuriesIncident investigationFinal reportCessna 172 · Teterboro, NJProbable Cause The probable cause of this incident was the TEB ground controller's failure to direct N316AS to hold short of runway 24 when issuing taxi instructions to the aircraft as required FAA Order 7110.65, paragraph 3-7-2 (2a); Taxi and Ground Movement…NTSB OPS08IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-700 · Seattle, WAThe diverted attention during taxi of the flight crew in the other aircraft. Contributing to the incident was the air traffic control clearance was not followed by the flight crew of the other aircraft.NTSB LAX08CA053Accident · Minor injuriesData collectionFinal reportCessna 172N · Beaver Marsh, ORThe pilot's inadequate in-flight planning/decision to land on a snow covered runway without first determining the depth of the snow.