NTSB investigations
15 cases where the first occurrence was “Cargo shift”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1997 | 2 |
| 2000 | 1 |
| 2003 | 2 |
| 2005 | 1 |
| 2006 | 3 |
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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 120) 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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 120) 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 ANC06LA137Accident · No injuriesLimited investigationFinal reportAerospatiale SA319B · Port Alsworth, AKThe pilot's failure to adequately secure the external load rigging of an airplane that was suspended from the helicopter, which resulted in a load shift during cruise flight, producing an abrupt nose-down attitude, and the severing of the tailrotor drive…NTSB DFW06CA204Accident · No injuriesData collectionFinal reportRon Burleigh Air Cam · Post, TXThe pilot's failure to maintain clearance with power lines while making a precautionary landing.NTSB ANC06LA064Accident · No injuriesLimited investigationFinal reportRobinson R44 · Skwentna, AKThe pilot's improper rigging of the external sling load, which allowed the suspended load/cargo cable to entangle and disable the tail rotor control, resulting in a loss of control during cruise and an in-flight collision with terrain.NTSB CHI05IA273Incident · No injuriesIncident investigationFinal reportConvair Div. of Gen. Dynamics 440 · Kenosha, WIThe flight crew failed to verify that the cargo was secured before takeoff.NTSB LAX04LA116Accident · No injuriesLimited investigationFinal reportHughes 369D · Wahiawa, HIThe pilot's failure to properly secure the external sling load, which allowed the load to shift, and subsequently strike and remove the tail rotor.NTSB ANC03GA023Accident · Serious injuriesFinal reportBell 212 · McMurdo Station, AYThe pilot's continued operation of the helicopter with an unstable external load, which resulted in damage to the cargo hook assembly, adjacent throttle controls, and subsequent loss of engine power, precipitating an emergency descent and impact with terrain.…NTSB CHI00LA312Accident · No injuriesLimited investigationFinal reportCessna 208B · Belleville, MIthe pilot's improper securing of the cargo that led up to the cargo shift during takeoff roll. A factor was the cargo restraint failure.NTSB CHI98LA053Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-15 · Syracuse, NYThe pilot's inadequate preflight to ensure that the cargo pallets were properly secured. Also causal was the the improper securing of the pallets.NTSB NYC97LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to secure the cargo. A factor was the pilot's failure to perform weight and balance calculations.NTSB CHI95LA078Accident · No injuriesLimited investigationFinal reportBoeing 747-238B · Belleville, MIthe failure of company maintenance personnel to adequately secure the cargo pallets, and the failure of the flightcrew to detect the deficiency during their preflight inspection.NTSB BFO93FA016Accident · 1 fatalField investigationFinal reportBeech C-45G · Elkridge, MDFailure of the pilot to properly secure the cargo, which allowed a shift in the center of gravity during a missed approach maneuver and resulted in subsequent loss of aircraft control and flying speed. A factor related to the accident was failure of the pilot…NTSB ANC91LA060Accident · No injuriesLimited investigationFinal reportHughes 500-D · Togiak, AKThe pilot's failure to secure the cargo prior to the flight. Contributing to the accident was the rough, uneven terrain.NTSB FTW89LA041Accident · Serious injuriesLimited investigationFinal reportDouglas DC-3 · Laredo, TXThe pic's disregard for the security of the cargo that permitted its shift during the takoeff roll. This resulted in an aft CG situation and a subsequent stall and loss of aircraft control. A contributing factor in the accident was the mismanagement of the…NTSB CHI85LA227Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Cleveland, OHOn takeoff, a tackel box slid forward and jammed the cyclic. The plt attempted to return to the landing pad, however, one of the skids missed the pad and the acft began to roll until the main rotor contacted the roof of a garage.NTSB ANC85LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Minchumina, AKThe acft made a hard landing on a frozen lake during a precautionary landing. The plt said that cargo on board had shifted in flt and he also had a loss of 15 mph in airspeed. Thinking it might be an icing problem, the plt made the unscheduled landing. No ice…