NTSB investigations, 2015
63 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\") = 2015
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") = 2015 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 ERA15CA209Accident · No injuriesData collectionFinal reportCessna 150D · Balsam Grove, NCThe pilot's decision to attempt an off airport takeoff, and failure to maintain adequate clearance during the initial climb in crosswind conditions, which resulted in a collision with trees.NTSB CEN15LA212Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze · Smithville, TXThe noncertificated pilot's loss of directional control during takeoff, which resulted in impact with a utility pole and hangar. Contributing to the accident was the pilot's failure to obtain flight instruction before attempting to fly the aircraft.NTSB CEN15LA219Accident · No injuriesLimited investigationFinal reportSocata TBM700 · Evart, MIThe pilot's failure to follow the Before Landing checklist and to extend the landing gear and the flight instructor’s inadequate supervision, which resulted in a gear-up landing.NTSB GAA15CA075Accident · Minor injuriesData collectionFinal reportHead Balloons AX8 105 - NO Series · Intercourse, PAThe pilot's selection of unsuitable terrain/location for takeoff in gusting wind conditions, resulting in a collision with a building, and substantial damage to the hot air balloon.NTSB WPR15FA143Accident · 4 fatalField investigationFinal reportCessna T210M · Challis, IDThe pilot's attempt to depart in conditions that resulted in the airplane having insufficient performance capability, which resulted in a collision with a tree.NTSB CEN15WA186Accident · 1 fatalForeign investigationRobinson R44 - II · Modrava, CzechiaOn March 29, 2015, at 0920 universal coordinated time (UTC), a Robinson model R44 Raven II helicopter, Czech Republic registration OK-RRJ, serial number 12464, sustained substantial damage when it collided with wooded terrain within Šumava National Park, near…NTSB WPR15LA132Accident · No injuriesLimited investigationFinal reportBeech B23 · Flagstaff, AZThe pilot's failure to maintain directional control during landing.NTSB ERA15LA165Accident · No injuriesLimited investigationFinal reportCessna 150 · Masscotte, FLThe pilot's failure to use carburetor heat during the flight while operating in conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's decision to take off…NTSB ERA15CA157Accident · No injuriesData collectionFinal reportMooney M20K · Laurel, MDThe pilot's improper decision to attempt a nighttime landing at an unsuitable airport, which resulted in a collision with the precision approach path indicator.NTSB WPR15FA125Accident · 1 fatalField investigationFinal reportBAE Systems MK-67 Hawk · Yuma, AZThe pilot’s initiation of an early rotation during takeoff, which led to an aerodynamic stall and loss of airplane control. Contributing to the accident were the pilot's use of nose up pitch trim and the operator's policy to use nose-up pitch trim during…NTSB CEN15CA168Accident · No injuriesData collectionFinal reportJones Ronald C Bearhawk · Walters, OKThe pilot did not maintain control of the airplane during the landing roll at night on an unlit grass strip.NTSB ERA15CA143Accident · No injuriesData collectionFinal reportPiper J3C 65 · Clermont, FLThe pilot's failure to land the airplane within the desired touchdown zone, resulting in a long landing and collision with a fence.NTSB CEN15LA157Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Frankenmuth, MIThe failure of the engine due to a lack of oil lubrication for reasons that could not be determined during postaccident examinations.