NTSB investigations
15 cases where NTSB found Initial training.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2024 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '04031010')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '04031010')) 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 ANC25LA008Accident · Serious injuriesClass 3 · LimitedFinal reportCub Crafters CC18-180 · Anchorage, AKThe incorrect installation of the rear flight control stick, resulting in the pilot’s inability to control the pitch attitude, coupled with the pilot’s inadequate control system check before departure, all which resulted in an aerodynamic stall during takeoff.NTSB DCA23LA384Accident · No injuriesClass 3 · LimitedFinal reportBoeing 767-322 · Houston, TXThe first officer’s improper control inputs after the airplane touched down. Contributing to the severity of the damage was the flight crew’s lack of recognition that the speedbrakes were not armed, which led to their delayed deployment.NTSB WPR21FA143Accident · 5 fatalClass 3 · FieldFinal reportAirbus Helicopters AS350-B3 · Palmer, AKThe pilot’s failure to adequately respond to an encounter with whiteout conditions, which resulted in the helicopter’s collision with terrain. Contributing to the accident was the (1) operator’s inadequate pilot training program and pilot competency checks,…NTSB WPR19MA177Accident · 11 fatalClass 2 · MajorFinal reportBeech 65-A90 · Mokuleia, HIThe pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…NTSB DCA18IA269Incident · Minor injuriesIncident investigationFinal reportDJI Phantom · Blacksburg, VAthe drone pilot's incorrect control inputs due to insufficient knowledge of the aircraft flight manual procedures. Contributing to the incident was the close proximity of the observers, and the decision to conduct a demonstration near the observers in a…NTSB DCA18IA092Incident · No injuriesIncident investigationFinal reportBoeing 777 222 · Honolulu, HIthe fracture of a fan blade due to P&W's continued classification of the TAI inspection process as a new and emerging technology that permitted them to continue accomplishing the inspection without having to develop a formal, defined initial and recurrent…NTSB DCA18CA001Accident · No injuriesData collectionFinal reportBoeing 737 7H4 · Chicago, ILthe mechanical failure of the tugs fuel governor, which made it difficult for the ramp agent to stop the tug. Contributing to the accident was the lack of guidance on how ground personnel were to handle vehicle malfunctions.NTSB CEN17LA176Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Gypsum, KSA total loss of engine power during a low-altitude agricultural application flight for reasons that could not be determined during detailed examinations. Contributing to the accident was the pilot’s failure to follow the airplane manufacturer's emergency…NTSB CEN17LA029Accident · No injuriesLimited investigationFinal reportBeech 100 · Jeffersonville, INThe pilot’s inadequate preflight planning, his decision to take off knowing the airplane was over its gross takeoff weight, and his failure to abort the takeoff after he realized that the airplane was not accelerating as expected, which resulted in a runway…NTSB GAA16CA512Accident · No injuriesData collectionFinal reportAir Tractor AT802 · Wilson, ARThe pilot’s failure to adequately survey the area of operation and his subsequent failure to maintain clearance from power lines during an agricultural application flight.NTSB CEN14GA109Accident · Serious injuriesFinal reportAmerican Eurocopter AS350B3 · Encino, TXThe pilot’s failure to maintain directional control while maneuvering, which resulted in a loss of tail rotor effectiveness. Contributing to the accident were the pilot’s limited experience in the operating environment and lack of formal mission training.NTSB ANC13FA017Accident · Serious injuriesField investigationFinal reportEurocopter AS350 B3 · Beluga, AKThe pilot's failure to stabilize the external load, which led to the synthetic long-line separating about midspan and the remaining line becoming entangled in the tail rotor gearbox output shaft and resulted in the separation of the tail rotor gearbox and…NTSB ANC12GA114Accident · No injuriesFinal reportQuest Kodiak 100 · Anchorage, AKThe pilot's failure to maintain directional control while landing, which resulted in a collision with the water. Contributing to the accident were the pilot's lack of experience conducting waterborne operations in the accident make and model airplane and the…NTSB OPS10IA014Incident · No injuriesIncident investigationFinal reportBoeing 737 · Worton, MDThe R10/12 controller issued an improper vector and descent clearance to the GII that put the airplane on a coverging flight path with the B737. Contributing to the incident was the failure of the FAA's training program to correct ongoing controller…NTSB OPS08IA015Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2C1 · Allentown, PAThe failure of both tower controllers to maintain awareness of the position of N736GV and ensure that the aircraft was clear of the runway before issuing a takeoff clearance to ASH7138.