NTSB investigations

8 cases where NTSB found Type/qual of instruct/training.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20092026

NTSB investigations per year, 2009–2026: 8 cases
2009	1
2011	1
2012	1
2013	2
2019	1
2021	1
2023	1

Where

Open the map

Latest cases

Query with SQL

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", '02031535')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\", '02031535'))
  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", '02031535'))
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 CEN23FA125Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Port O'Connor, TXThe pilot’s initiation of the visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of helicopter control. Contributing to the accident was the pilot’s flicker vertigo during the flight.Mar 7, 2023 · N494SH · Destroyed NTSB DCA21LA096Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL-600-2C10 · Los Angeles, CAthe improper retraction of the main cabin door, which resulted in the flight attendant falling when she opened the door at the destination.Mar 16, 2021 · N706SK · No damage 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…Jun 22, 2019 · N256TA · Destroyed NTSB CEN14LA036Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Superior, WIThe failure of the pilot who was flying the trail airplane to maintain separation from the lead airplane. Contributing to the accident was the inadequate pilot training for formation skydiving operations.Nov 2, 2013 · N70520 · 2 aircraft · Destroyed NTSB CEN13LA342Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Morrilton, ARThe flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.Jun 10, 2013 · N6412G · Substantial damage NTSB CEN12LA414Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Glenwood Springs, COThe pilot's decision to fly into a mountainous area where conditions were such that the airplane was unable to climb above rising terrain. Contributing to the accident was the pilot's insufficient pilot-in-command experience and inadequate training in…Jun 30, 2012 · N917SA · Substantial damage NTSB OPS11IA653Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fairbanks, AKInadequate air traffic control actions that failed to establish and maintain required separation between the two airplanes. Contributing to the incident was inexperience on the part of the local controller, inadequate oversight by the tower…Jun 14, 2011 · N121WV · 2 aircraft · No damage NTSB OPS09IA009Incident · No injuriesIncident investigationFinal reportBombardier DHC-8-202 · Cleveland, OHThe local controller did not visually scan the runways and ensure that the E145 had crossed runway 24L prior to issuing a takeoff clearance to the DH8, did not ensure separation between the two airplanes, and did not cancel takeoff clearance for the DH8 in a…Jun 26, 2009 · N375PH · 2 aircraft · No damage