NTSB investigations
17 cases where NTSB found Person.
Cases per year
| 2009 | 1 |
|---|---|
| 2014 | 2 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 2 |
| 2024 | 3 |
| 2026 | 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\", '03022035')) 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", '03022035')) 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 ERA26LA207Accident · 1 fatalClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Scotts Fork, VAThe photographer’s failure to remain clear of an active taxiway.NTSB ERA24LA384Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · DeLand, FLThe parachutist’s failure to control his canopy which resulted in a downwind landing, an overshoot of the drop zone, and collision with a departing airplane.NTSB WPR24LA300Accident · No injuriesClass 4 · LimitedFinal reportPacific Aerospace 750XL · Mulino, ORThe skydiver’s unintentional parachute deployment and subsequent entanglement with the airplane’s horizontal stabilizer.NTSB CEN24LA197Accident · Serious injuriesClass 4 · LimitedFinal reportCessna U206 · Butler, MOThe jumper’s unintentional deployment of his emergency parachute and subsequent impact with the airplane’s horizontal stabilizer.NTSB CEN24LA032Accident · Minor injuriesClass 4 · LimitedFinal reportTom Hodgson 29 · Kokomo, INThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR23LA259Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A-1B · Las Vegas, NVThe pilot’s unsafe inflight operation of the airplane and failure to maintain clearance from a person on the ground, which resulted in a serious injury.NTSB WPR21LA306Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-85 · Woodburn, ORThe pilot’s failure to maintain clearance during takeoff from a person on the ground who sustained a serious injury as a result of the collision.NTSB CEN20CA120Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Ankeny, IAThe pilot's improper starting procedure, which allowed the airplane to move forward over the wheel chocks and impact him and a hangar when he subsequently hand propped the engine.NTSB GAA20CA025Accident · Serious injuriesData collectionFinal reportCessna 172 · Key West, FLThe pilot’s and the passenger's improper decision to have the passenger attempt to move a wheel chock while the propeller was turning, which resulted in a serious injury.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 ANC18LA027Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC 6 Twin Otter · Arctic OceanThe flight crew's improper decision to deliberately operate the airplane at low altitude and along a flightpath that resulted in a collision with a pedestrian after takeoff. Contributing to the accident was the pedestrian's proximity to the runway.NTSB CEN18LA027Accident · Serious injuriesLimited investigationFinal reportRiggs Kenneth W T Bird II · St Mary's, KSThe loss of engine power due to a propeller failure when the passenger’s hat exited the cockpit and impacted the three-bladed pusher propeller, separating one of the propeller blades.NTSB GAA17CA443Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Berlin, MDThe ground crewman’s failure to visually check the runway before crossing it in a vehicle, which resulted in he and the vehicle being struck by the landing airplane.NTSB CEN17LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-235 · Harrisonville, MOThe pilot's failure to maintain a safe distance between the airplane and a person on the ground, which resulted in serious injuries to the person.NTSB CEN15CA029Accident · No injuriesData collectionFinal reportDoubleday Donald Thorp TS-18CW · Reklaw, TXThe pilot's inadequate monitoring of the airplane's approach path which resulted in long landing and a subsequent runway excursion. Contributing to the accident was the pilot's delayed decision to apply the brakes, inflight traffic, and nearby pedestrians.NTSB DCA14CA083Accident · Serious injuriesData collectionFinal reportAirbus A330 323 · Seattle (Pacific Ocean)the flight attendant inadvertently tripping over a passenger's foot that was protruding into the aisle, which resulted in the flight attendant fracturing her foot.NTSB CEN09LA265Accident · Serious injuriesLimited investigationFinal reportT Bird T Bird II · Carlock, ILThe pilot's failure to gain sufficient altitude during the takeoff in order to avoid contacting the cameraman. Contributing to the accident was the pilot's lack of experience.