Skip to content

NTSB investigations, OR

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA' 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.\"eventStateOrRegion\" = 'OR' 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.

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."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA'
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 SEA72DYA09Accident · No injuriesClosedLuscombe 8A · Jordan Vally, ORAug 18, 1971 · N72019 · Substantial damage NTSB SEA72DYI06Accident · Minor injuriesClosedBell 47G3B · Selma, ORAug 13, 1971 · N73241 · Substantial damage NTSB SEA72FYI05Accident · No injuriesClosedBeech B23 · Bend, ORAug 11, 1971 · N7603R · Substantial damage NTSB SEA72FYI04Accident · No injuriesClosedKaman HUK-1 · Central Pt, ORAug 7, 1971 · N9847 · Substantial damage NTSB SEA72FYC15Accident · No injuriesClosedCessna A188 · St.Johns, ORAug 2, 1971 · N8073V · Substantial damage NTSB SEA72AS005Accident · 2 fatalClosedCallair A-9 · Nyssa, ORAug 2, 1971 · N3558G · 2 aircraft · Destroyed NTSB SEA72DYI03Accident · No injuriesClosedCessna 172 · Lakeview, ORAug 1, 1971 · N8904B · Substantial damage NTSB SEA72FYC14Accident · 1 fatalClosedBell 47-G3B · Mt Vernon, ORJul 31, 1971 · N4079G · Destroyed NTSB SEA72FYC12Accident · 1 fatalClosedCallair A-9 · Hermiston, ORJul 29, 1971 · N375MC · 2 aircraft · Minor damage NTSB SEA72FYC11Accident · No injuriesClosedCessna 150 · Albany, ORJul 27, 1971 · N3625J · Substantial damage NTSB SEA72AS004Accident · No injuriesClosedDouglas DC-3C · Redmond, ORJul 26, 1971 · N51041 · Substantial damage NTSB SEA72DYC09Accident · No injuriesClosedChampion 7FC · Sandy, ORJul 25, 1971 · N9051B · Substantial damage NTSB SEA72DYC08Accident · No injuriesClosedBell 47G3B1 · Legrande, ORJul 20, 1971 · N1324X · Destroyed NTSB SEA72DYC07Accident · No injuriesClosedStinson 108-1 · Salem, ORJul 18, 1971 · N9023K · Substantial damage NTSB SEA72DYC05Accident · No injuriesClosedPiper J3C-65 · Beaverton, ORJul 5, 1971 · N33551 · Substantial damage NTSB SEA72FYC02Accident · Serious injuriesClosedBeech 23 · Seaside, ORJul 3, 1971 · N8707M · Destroyed NTSB SEA72DYC04Accident · No injuriesClosedPiper J-3 · Dayton, ORJul 3, 1971 · N11CJ · Substantial damage NTSB SEA72DYC03Accident · No injuriesClosedMooney M20C · Culver, ORJul 3, 1971 · N6666U · Substantial damage NTSB SEA72DYC01Accident · Minor injuriesClosedCessna A185E · John Day, ORJul 1, 1971 · N4740Q · Destroyed NTSB SEA71DYC47Accident · No injuriesClosedCessna 172F · Lostine, ORJun 30, 1971 · N8303U · Destroyed NTSB SEA71FYC46Accident · Minor injuriesClosedCessna 172G · Mt.Hood, ORJun 20, 1971 · N1165F · Substantial damage NTSB SEA71FYI26Accident · Serious injuriesClosedPitts S1C · Creswell, ORJun 19, 1971 · N75E · Substantial damage NTSB SEA71AS047Accident · 5 fatalClosedPiper PA-32 · Meacham, ORJun 14, 1971 · N4070W · Destroyed NTSB SEA71FYC43Accident · No injuriesClosedCessna 182B · Enterprise, ORJun 12, 1971 · N2513G · Substantial damage NTSB SEA71FYC42Accident · 1 fatalClosedHiller UH12A · Brooks, ORJun 11, 1971 · N8178H · Destroyed NTSB SEA71DYA34Accident · Minor injuriesClosedPiper PA-25 · Arock, ORJun 6, 1971 · N7302Z · Destroyed NTSB SEA71AS046Accident · 3 fatalClosedPiper PA-28 · Clatskanie, ORJun 2, 1971 · N3968R · Destroyed NTSB SEA71FYC41Accident · No injuriesClosedHughes 269A · Wilsonville, ORMay 29, 1971 · N8850F · Substantial damage NTSB SEA71AS045Accident · 1 fatalClosedPiper PA-22 · Springfield, ORMay 23, 1971 · N2129A · Destroyed NTSB SEA71AS044Accident · 2 fatalClosedPiper PA-18 · Adel, ORMay 19, 1971 · N3596P · Destroyed NTSB SEA71FYI25Accident · Serious injuriesClosedPiper PA-18 · Plush, ORMay 11, 1971 · N4739A · Destroyed NTSB SEA72DYC10Accident · No injuriesClosedPiper PA-20 · Woodburn, ORMay 7, 1971 · N7650K · Substantial damage NTSB SEA71FYC40Accident · No injuriesClosedCessna 182 · Salem, ORMay 6, 1971 · N3295U · Substantial damage NTSB SEA71DYI24Accident · Minor injuriesClosedAeronca 7AC · Central Pt, ORMay 1, 1971 · N2412E · Substantial damage NTSB SEA71FYC39Accident · No injuriesClosedPiper PA-28 · Troutdale, ORApr 30, 1971 · N7746N · Substantial damage NTSB SEA71FYC38Accident · No injuriesClosedBell 47G-3B · Elgin, ORApr 30, 1971 · N73940 · Substantial damage NTSB SEA71FYC37Accident · No injuriesClosedMaule M-4 · Aurora, ORApr 29, 1971 · N4727T · Substantial damage NTSB SEA71FYC35Accident · No injuriesClosedHughes 269B · Portland, ORApr 26, 1971 · N9477F · Substantial damage NTSB SEA71FYC36Accident · No injuriesClosedTaylorcraft BC12-D · Sandy, ORApr 25, 1971 · N96324 · Substantial damage NTSB SEA71DVQ23Accident · Minor injuriesClosedCessna 120 · Elkton, ORApr 25, 1971 · N72560 · Substantial damage NTSB SEA71DYC30Accident · No injuriesClosedBell 47G5 · Corvallis, ORApr 15, 1971 · N1420 · Substantial damage NTSB SEA71DVQ22Accident · No injuriesClosedBell 47G3B · Days Creek, ORApr 7, 1971 · N8455E · Substantial damage NTSB SEA71DWA34Accident · Minor injuriesClosedCessna 172I · Mulino, ORApr 5, 1971 · N8478L · Destroyed NTSB SEA71FVQ21Accident · Serious injuriesClosedCessna 150H · Cotage Grove, ORApr 1, 1971 · N7135S · Destroyed NTSB SEA71DWA33Accident · No injuriesClosedCessna 140 · Tigard, ORApr 1, 1971 · N76294 · Substantial damage NTSB SEA71FVQ20Accident · 1 fatalClosedLuscombe 8E · Lakeview, ORMar 26, 1971 · N1867K · Destroyed NTSB SEA71DVQ17Accident · No injuriesClosedPiper PA-18 · Mckenzie Br., ORMar 15, 1971 · N9016Y · Substantial damage NTSB SEA71DWA29Accident · No injuriesClosedPiper PA-28 · Hermiston, ORMar 6, 1971 · N4521R · Substantial damage NTSB SEA71DWA31Accident · No injuriesClosedPiper PA-32 · Condon, ORFeb 25, 1971 · N3623W · Substantial damage NTSB SEA71DWA28Accident · No injuriesClosedChampion 7GCB · Union, ORFeb 19, 1971 · N8982R · Substantial damage