NTSB investigations
22 cases where the defining event was Aircraft loading event.
Cases per year
| 2012 | 2 |
|---|---|
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 1 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 2 |
| 2025 | 1 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '010') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '010') 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 DCA26WA076AccidentClass 5 · ForeignBoeing 737 · Leeds, United KingdomNTSB DCA25WA054IncidentClass 5 · ForeignBoeing 737 · Perth, AustraliaNTSB DCA24WA257IncidentClass 4 · ForeignBoeing 737 · Port Moresby, Papua New GuineaNTSB CEN23LA326Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Charles City, IAThe pilot’s improper preflight of the helicopter to ensure that it was within the loading and performance limitations that resulted in settling and impact with terrain during initial climb.NTSB ERA23LA315Accident · Serious injuriesClass 4 · LimitedFinal reportHead Balloons AX8-88 · Guilford, CTThe pilot’s inadequate supervision of the boarding process and the ground crewmember’s failure to immediately let go of the balloon after it began an inadvertent climb.NTSB DCA23WA184Occurrence · Serious injuriesClass 5 · ForeignBoeing 767-300F · Derby, United KingdomNTSB DCA22WA120Incident · Minor injuriesClass 5 · ForeignBoeing 737 · Almeria, SpainNTSB GAA18CA534Accident · No injuriesData collectionFinal reportRobinson R44 · Girdwood, AKThe fisherman's fishing rod striking the helicopter’s rotating main rotor disk during loading.NTSB CEN17LA350Accident · No injuriesLimited investigationFinal reportEmbraer EMB 120ER · Greeley, COThe bus driver's failure to maintain clearance from the standing airplane during dark night conditions. Contributing to the accident was the airport's lack of an escort for the bus.NTSB GAA17CA347Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Watervliet, MIThe flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.NTSB DCA17WA127Incident · No injuriesForeign investigationBoeing 747 · Glasgow, United KingdomThe United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on March 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as…NTSB DCA17WA054Incident · No injuriesForeign investigationBoeing 737 · Sydney, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on December 17, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB CEN16LA089Accident · No injuriesLimited investigationFinal reportCessna 208B · Grand Forks, NDThe pilot's failure to properly calculate the airplane's weight and balance and center of gravity, which resulted in the tail striking the ground.NTSB GAA16LA046Accident · Serious injuriesLimited investigationFinal reportU-Fly-It Aerolite 103 · Midland, VAThe pilot’s failure to attain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during takeoff with the airplane’s center of gravity aft of its limit, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA15LA190Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Winchester, TNThe pilot's inadequate weight and balance and performance planning, including his decision to take off with more passengers than permitted, and his exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an…NTSB DCA15LA011Accident · No injuriesLimited investigationFinal reportBoeing 737 330 · Lanai, HIthe improper loading and securing of the cargo pallets, which shifted on departure, resulting in substantial damage to the aft pressure bulkhead.NTSB ERA14CA397Accident · Minor injuriesData collectionFinal reportRaytheon G36 · Milton, FLThe pilot's inadequate preflight planning, which resulted in an attempted takeoff over the airplane's maximum gross weight and beyond its aft center of gravity limit. Contributing to the accident was the pilot's lack of total flight experience in the aircraft…NTSB ERA14FA343Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · North Captiva Island, FLThe pilot’s failure to secure the cargo in the cargo compartment, which resulted in a weight shift that led to the center of gravity exceeding its aft limit during a go-around attempt and a subsequent aerodynamic stall. Also causal to the accident were the…NTSB CEN13IA563Incident · Minor injuriesIncident investigationFinal reportPilatus PC-12/47E · Austin, TXThe pilot’s improper weight and balance calculations, which resulted in the airplane exceeding its weight and center-of-gravity limits and led to a loss of pitch control during takeoff, and the operator’s failure to obtain required weight information and to…NTSB CEN13LA421Accident · No injuriesLimited investigationFinal reportCessna 208B · Chicago, ILThe gate agent’s premature removal of the tailstand without confirming with the flight crew that it was safe to remove, which allowed the airplane to tilt backward when a passenger stood up and stepped toward the back of the airplane.NTSB DCA12WA159Accident · No injuriesForeign investigationBoeing 777 · Rome, ItalyOn September 30, 2012, about 1305 Coordinated Universal Time (UTC), a Boeing 777-200 sustained damage to the forward left passenger door and aircraft structure when a jetbridge was moved during boarding operations at Rome Fiumicino Airport, Rome, Italy. There…NTSB ANC12CA018Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Beluga, AKGround personnel's movement of cargo in windy conditions, which allowed a previously secured cargo sack to blow into the main rotor blades.