NTSB investigations, 2018
67 cases where the sequence of events included Collision during takeoff/land.
Cases, newest first
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\") = 2018
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '490' 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") = 2018 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '490' 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 GAA18CA411Accident · No injuriesData collectionFinal reportEipper Quicksilver · Marietta, SCThe pilot's improper landing flare, which resulted in a loss of directional control.NTSB GAA18CA221Accident · No injuriesData collectionFinal reportCessna 120 · Iola, WIThe pilot’s decision to reject the takeoff from a snow-covered grass surface, which resulted in a nose-over.NTSB GAA18CA211Accident · No injuriesData collectionFinal reportCessna A185 · Sterling, AKThe pilot’s failure to maintain clearance from trees during the approach to land due to the sun glare.NTSB CEN18FA132Accident · 2 fatalField investigationFinal reportCessna 150 · Marion, INThe failure of both pilots to see and avoid the other airplane as they converged on intersecting runways. Contributing to the accident was the jet pilot's not monitoring the airport's traffic advisory frequency, known reduced visibility of the intersecting…NTSB GAA18CA185Accident · No injuriesData collectionFinal reportUltramagic N 300 · Cave Creek, AZThe balloon pilot’s decision to add heat to the envelope with a tree branch protruding into the envelope that caught fire.NTSB ERA18LA116Accident · Minor injuriesClass 3 · LimitedFinal reportLindstrand Balloons 105A · Wesley Chapel, FLThe pilot's failure to maintain adequate clearance from powerlines during landing approach, which resulted in an inflight collision with the powerlines.NTSB CEN18LA123Accident · 1 fatalLimited investigationFinal reportMills Michael S1L · Dewitt, MIThe pilot's failure to see and avoid power lines due to sun glare.NTSB ANC18LA027Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC 6 Twin Otter · Arctic OceanThe flight crew's improper decision to deliberately operate the airplane at low altitude and along a flightpath that resulted in a collision with a pedestrian after takeoff. Contributing to the accident was the pedestrian's proximity to the runway.NTSB GAA18CA197Accident · No injuriesData collectionFinal reportPiper PA28 · Cedar Key, FLThe pilot’s unstabilized approach, which resulted in a long landing and subsequent runway overrun.NTSB WPR18LA105Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-180 · Montague, CAImpact with powerlines and terrain after takeoff for reasons that could not be determined based on the available information.NTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.NTSB GAA18CA146Accident · Minor injuriesData collectionFinal reportCessna 172 · Gatesvile, TXThe pilot’s failure to maintain directional control during initial climb in a gusty condition.NTSB WPR18LA092Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Obyan, SarkThe pilot's inadequate preflight fuel planning and inadequate in-flight fuel monitoring which resulted in a total loss of engine power due to fuel exhaustion and an emergency landing and subsequent impact with a ditch.NTSB WPR18LA089Accident · No injuriesLimited investigationFinal reportShanks V Roger Vari EZE · Santa Monica, CAAn undetected fluid leak in the right brake line, which resulted in a reduction of braking effectiveness at the right wheel and a loss of directional control during the landing roll.NTSB GAA18CA125Accident · Serious injuriesData collectionFinal reportBaker Victor R Kitfox · Carson City, NVThe pilot-receiving-instruction’s failure to maintain directional control during takeoff.NTSB ERA18WA261Accident · Serious injuriesForeign investigationSkyrunner MK 3.2 · Margham, Dubai, United Arab EmiratesThe government of the United Arab Emirates has notified the NTSB of an accident involving a SkyRunner, MK-3.2 Powered Parachute that occurred on February 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Arab…NTSB GAA18CA107Accident · No injuriesData collectionFinal reportBell UH 1H · Van Nuys, CAThe pilot’s failure to maintain clearance from a stationary helicopter during landing. Contributing to the accident was the ground crew’s failure to ensure that the helicopter would clear the stationary helicopter.