NTSB investigations, 2023, OH

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026
NTSB investigations, 2023, OH per year, 1962–2026: 4,364 cases
19621
19631
1964199
1965184
1966193
1967189
1968187
1969129
1970142
1971147
1972121
1973124
1974142
1975101
1976103
1977112
197899
1979115
1980109
198181
198281
198381
198484
198573
198659
198769
198859
198974
199052
199152
199256
199346
199452
199554
199644
199743
199829
199938
200046
200133
200239
200346
200434
200537
200623
200741
200843
200932
201037
201143
201230
201322
201429
201517
201634
201733
201833
201927
202022
202127
202230
202319
202416
202523
202623

Latest 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 year(c.\"eventDate\") = 2023
    AND c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
  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.

NTSB ERA24LA064Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Sidney, OHThe pilots’ improper landing flare, which resulted in a hard landing, runway excursion, and subsequent impact with a terminal sign and taxi light.Dec 12, 2023 · N6643H · Substantial damageNTSB ERA24FA026Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Marion, OHA descent and impact with terrain for undetermined reasons.Oct 31, 2023 · N44601 · DestroyedNTSB ERA24LA014Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Ottawa, OHA total loss of engine power due to the formation of carburetor ice..Oct 22, 2023 · N6757P · Substantial damageNTSB ERA24LA002Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Gallipolis, OHA collapse of the nose landing gear during landing, which resulted in a runway excursion and collision with an approach lighting system.Oct 2, 2023 · N7461W · Substantial damageNTSB ERA23LA385Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206 · Port Clinton, OHThe pilot’s failure to detect and avoid unmarked powerline(s) while attempting to take off from a river.Sep 30, 2023 · N34PL · Substantial damageNTSB ERA23LA377Accident · Serious injuriesClass 4 · LimitedFinal reportAvian Balloon Skyhawk · Bucyrus, OHThe balloon pilot’s bounced landing, which resulted in the basket tipping over and a serious injury to a passenger.Sep 21, 2023 · N2067Q · Minor damageNTSB ERA23LA362Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Cincinnati, OHA loss of engine power for reasons that could not be determined.Sep 2, 2023 · N6868D · Substantial damageNTSB ERA23LA344Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Fostoria, OHA loss of engine power for unknown reasons.Aug 20, 2023 · N1152K · Substantial damageNTSB ERA23LA327Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Leipsic, OHThe incorrect assembly of the turbine engine’s reduction gear box second-stage ring gear, which resulted in an internal failure of multiple engine components and a total loss of power.Aug 4, 2023 · N5048S · Substantial damageNTSB ERA23FA317Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Springfield, OHThe pilot’s failure to remain clear of powerlines during an agricultural spraying operation.Jul 29, 2023 · N652HA · Substantial damageNTSB DCA23LA383Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · East Palestine, OHAn inadvertent encounter with convectively induced turbulence (CIT) during descent.Jul 24, 2023 · N279WN · No damageNTSB ERA23LA309Accident · Serious injuriesClass 3 · LimitedFinal reportBell 206-L4 · Caldwell, OHThe helicopter’s uncontrolled vertical descent and impact with terrain for reasons that could not be determined.Jul 23, 2023 · N482TJ · Substantial damageNTSB ERA23LA306Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300 · Mount Gilead, OHThe pilot’s improper fuel management by not switching fuel tanks in flight, resulting in fuel starvation to the engine and a total loss of engine power.Jul 21, 2023 · N9519C · Substantial damageNTSB ERA23LA233Accident · Minor injuriesClass 4 · LimitedFinal reportRotorway Exec · Akron, OHThe non-certificated pilot’s failure to maintain control of the unregistered helicopter during landing.May 10, 2023 · UNREG · Substantial damageNTSB ERA23LA224Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Clyde, OHThe pilot’s inadequate fuel management, which resulted in fuel starvation and a forced landing.May 6, 2023 · N678FL · Substantial damageNTSB ERA23LA208Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6 · Eaton, OHThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Apr 26, 2023 · N327WC · Substantial damageNTSB ERA23FA200Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · London, OHThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.Apr 18, 2023 · N734GB · Substantial damageNTSB ERA23LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Cincinnati, OHThe pilot’s failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a parked airplane. Contributing was the marshaller’s improper marshalling techniques.Mar 21, 2023 · N7772B · Substantial damageNTSB ERA23LA112Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-31-350 · Middlefield, OHA runway overrun during a precautionary landing following a total loss of right engine power due to detonation and subsequent oil starvation. Contributing was the pilot’s failure to lower the flaps and the excessive airspeed at touchdown.Jan 18, 2023 · N101MA · Substantial damage