NTSB investigations, 2018
669 cases where the sequence of events included Collision with terr/obj (non-CFIT).
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\" = '470' 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" = '470' 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 WPR19LA011Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Indianapolis, INA total loss of engine power due to displacement of the dual magneto’s internal camshaft, which resulted in the magneto’s inability to produce spark.NTSB WPR19LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Hurricane, UTThe mechanic’s failure to properly align the engine exhaust crossover pipe during replacement, and his supervisor’s failure to properly inspect the installation, which resulted in an in-flight fire and the loss of engine power.NTSB GAA19CA031Accident · No injuriesData collectionFinal reportLeroux John F CCX-1865 · Carson City, NVThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground loop.NTSB GAA19CA050Accident · No injuriesData collectionFinal reportPiper PA28 · East Moriches, NYThe pilot’s delayed initiation of a go-around and his subsequent use of the improper go-around procedure, which resulted in a landing area overshoot.NTSB ERA19LA022Accident · No injuriesLimited investigationFinal reportPiper PA22 · Brownstown, INThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation. Contributing to the outcome was the student…NTSB GAA19CA082Accident · No injuriesData collectionFinal reportPiper PA28 · Waynesburg, PAThe student pilot's improper decision to maneuver the airplane through an area of construction and his subsequent failure to maintain clearance from a concrete pole barrier while taxiing.NTSB ERA19LA021Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Plant City, FLThe pilot’s failure to utilize carburetor heat in conditions conducive to the formation of carburetor icing, which resulted in a total loss of engine power.NTSB ERA19LA019Accident · No injuriesLimited investigationFinal reportCessna 172 · Lynchburg, VAThe stuck No. 2 cylinder exhaust valve, which resulted in a partial loss of engine power and a subsequent forced landing and impact with a ditch.NTSB ERA19LA017Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Opelika, ALThe improper torque application and ongoing inspection of an oil filter adaptor by maintenance personnel, which resulted in a loss of lubrication and a catastrophic engine failure.NTSB ERA19LA014Accident · Serious injuriesClass 3 · LimitedFinal reportHargrove Hummel Ultra Cruiser · Zephyrhills, FLThe pilot's failure to activate the airplane’s auxiliary fuel pump, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident were the impairing effects of the pilot’s medication on his performance.NTSB WPR19FA007Accident · 2 fatalClass 2 · FieldFinal reportCessna T240 · Payson, AZThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall/spin and a subsequent loss of control.NTSB GAA19CA024Accident · No injuriesData collectionFinal reportCessna 172 · Vergennes, VTThe pilot's failure to maintain clearance from trees while taxiing.NTSB GAA19CA022Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Cherry Ridge, PAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA19CA027Accident · No injuriesData collectionFinal reportPiper J3C · Camas, WAThe student pilot’s failure to maintain directional control during the landing roll.NTSB ERA19TA011Accident · No injuriesFinal reportBeech F33 · Reidsville, GAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB ERA19LA015Accident · No injuriesClass 3 · LimitedFinal reportAvid Avid Flyer · Grant-Valkaria, FLA total loss of engine power due to a carburetor malfunction, which resulted in a forced landing.NTSB ERA19LA012Accident · 3 fatalLimited investigationFinal reportPiper PA34 · Westhampton Beach, NYThe instructor's decision to conduct and continue a visual flight rules flight into instrument meteorological conditions with a known flight instrument anomaly, which resulted in spatial disorientation, causing a loss of airplane control and subsequent…NTSB CEN19FA005Accident · 1 fatalField investigationFinal reportPiper PA28 · Cartersville, GAThe pilot's inadequate preflight and inflight fuel planning and his decision to continue flight without stopping for fuel, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA19FA010Accident · 1 fatalClass 2 · FieldFinal reportVans RV8 · Culpeper, VAThe pilot's loss of attitude orientation while maneuvering at low altitude in dark night visual meteorological conditions, which resulted in impact with terrain.NTSB CEN19LA007Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman AA5 · Refugio, TXThe pilot’s improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation and the pilot’s failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and an…NTSB CEN19LA002Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Midland, TXThe loss of engine power due to excessive fuel flow.NTSB CEN19FA003Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Placedo, TXThe pilot's failure to maintain clearance from the antenna tower, a known obstruction, during the agricultural application flight. Contributing to the accident was glare from the sun which hindered the pilot's ability to see and avoid the antenna tower.NTSB WPR19TA009Accident · Serious injuriesFinal reportKreling Supercat · Three Rivers, MIThe pilot's failure to maintain the proper pitch attitude and adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB WPR19LA006Accident · 1 fatalClass 2 · LimitedFinal reportVans RV6 · Cape Girardeau, MOThe pilot's improper landing flare in gusting crosswind conditions, his failure to conduct a go-around, and his failure to maintain directional control, which resulted in a runway departure and nose-over.NTSB WPR19LA003Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Grass Valley, CAA loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.NTSB GAA19CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · Crowley, LAThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with vegetation and a subsequent loss of directional control.NTSB GAA19CA008Accident · Minor injuriesData collectionFinal reportCessna 188 · Rolla, MOThe pilot's failure to maintain directional control during takeoff in a left quartering tailwind.NTSB GAA19CA012Accident · No injuriesData collectionFinal reportBearden Biplane Sopwith Camel · Bolivar, MOThe pilot's failure to maintain directional control during landing.NTSB ANC19LA004Accident · Serious injuriesLimited investigationFinal reportAirborne X-Series · North Pole, AKThe student pilot's decision to fly the weight-shift-controlled airplane with no training in the airplane type, which resulted in a loss of control and impact with terrain shortly after takeoff.NTSB GAA19CA009Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · New Orleans, LAThe pilot’s failure to maintain directional control during a crosswind landing.NTSB GAA19CA006Accident · No injuriesData collectionFinal reportZenair CH 2000 · Topeka, KSThe pilot's improper landing flare, which resulted in a hard, bounced landing and a subsequent runway excursion.NTSB GAA19CA014Accident · No injuriesData collectionFinal reportCessna 172 · Stockton, CAThe student pilot's failure to maintain directional control during takeoff.NTSB GAA19CA011Accident · Minor injuriesData collectionFinal reportBeech 55 · San Antonio, TXThe pilot's improper takeoff trim setting and failure to properly secure his seatbelt, which resulted in a loss of airplane control. Contributing to the accident was the pilot's failure to follow the Before Takeoff checklist.NTSB GAA19CA016Accident · No injuriesData collectionFinal reportPiper PA24 · Winder, GAThe pilot’s failure to maintain an adequate approach path at night after an electrical failure, which resulted in the airplane striking runway lights.NTSB ERA19LA006Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 205 · Wagoner, OKMaintenance personnel’s improper maintenance of the magnetos, which resulted in a loss of engine power.NTSB ERA19CA002Accident · Serious injuriesData collectionFinal reportChampion 7FC · Myakka City, FLThe pilot's failure to maintain clearance from an obstacle during takeoff.NTSB WPR18LA278Accident · No injuriesClass 3 · LimitedFinal reportHoward DGA 15P · Kernville, CAA total loss of engine power during initial climb due to fuel starvation.NTSB WPR18FA279Accident · 1 fatalClass 2 · FieldFinal reportCessna 177RG · La Verne, CAThe pilot's failure to maintain adequate airspeed and the exceedance of the airplane's critical angle of attack during a turn, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was an undetermined engine…NTSB WPR18FA276Accident · 3 fatalClass 2 · FieldFinal reportCessna T210 · Silver City, IDThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while making a turn in gusting wind conditions while flying through hilly terrain, which resulted in an aerodynamic stall.NTSB GAA18CA580Accident · No injuriesData collectionFinal reportPiper PA28 · Van Nuys, CAThe pilot's failure to maintain directional control of the airplane during landing.NTSB GAA18CA571Accident · No injuriesData collectionFinal reportEurocopter AS350 · Ruidoso, NMThe pilot's failure to maintain the proper descent rate during landing. Contributing to the accident were the pilot’s failure to conduct preflight performance calculations, which resulted in his operating the helicopter in high-density altitude conditions,…NTSB ERA18LA265Accident · Minor injuriesLimited investigationFinal reportPiper PA32 · Bartow, FLA total loss of engine power after the separation of the No. 3 cylinder from the crankcase due to improper maintenance.NTSB CEN18FA391Accident · 3 fatalField investigationFinal reportAirbus Helicopters AS350 · Gustavus, AKThe pilot's failure to maintain main rotor speed after setting the engine fuel control to idle, which resulted in a loss of helicopter control and impact with water.NTSB ERA18FA264Accident · 2 fatalField investigationFinal reportDassault Falcon 50 · Greenville, SCThe operator's decision to allow a flight in an airplane with known, unresolved maintenance discrepancies, and the flight crew's failure to properly configure the airplane in a way that would have allowed the emergency or parking brake systems to stop the…NTSB CEN18FA387Accident · 1 fatalField investigationFinal reportBeech 200 · Oscoda, MIThe pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.NTSB GAA18CA581Accident · Minor injuriesData collectionFinal reportDe Havilland DHC 2 MK. I(L20A) · Kukaklek Lake, AKThe pilot’s failure to see and avoid a sand bar during a water takeoff, which resulted in the airplane impacting a river bank.NTSB GAA18CA566Accident · No injuriesData collectionFinal reportVans RV-14 · Heber City, UTThe pilot's loss of directional control during the landing roll and his subsequent attempted go-around.NTSB ERA18LA271Accident · Minor injuriesClass 3 · LimitedFinal reportBell OH 58A · Juana Diaz, PRA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18LA257Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Winter Haven, FLThe student pilot’s improper pitch attitude control during the initial climb, which resulted in a loss of airspeed, and his subsequent decision to conduct a 180° turn following the perceived anomaly, which resulted in a runway overrun.NTSB ERA18LA258Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Georgetown, SCA loss of directional control during landing due to overstress failure of the left seat’s left rudder pedal arm clevis, which occurred as a result of manufacturing defects.