Skip to content

Final NTSB investigations, 1969

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year

19622026

Final NTSB investigations, 1969 per year, 1962–2026: 171,584 cases
1962	72
1963	78
1964	5,253
1965	5,377
1966	5,912
1967	6,339
1968	5,199
1969	5,027
1970	4,915
1971	4,825
1972	4,430
1973	4,398
1974	4,565
1975	4,403
1976	4,314
1977	4,412
1978	4,624
1979	4,165
1980	3,921
1981	3,836
1982	3,545
1983	3,511
1984	3,403
1985	3,051
1986	2,824
1987	2,757
1988	2,651
1989	2,478
1990	2,451
1991	2,391
1992	2,293
1993	2,244
1994	2,190
1995	2,216
1996	2,091
1997	2,038
1998	2,061
1999	2,069
2000	2,026
2001	1,876
2002	1,868
2003	1,928
2004	1,776
2005	1,826
2006	1,644
2007	1,809
2008	1,714
2009	1,613
2010	1,561
2011	1,612
2012	1,578
2013	1,317
2014	1,321
2015	1,317
2016	1,344
2017	1,334
2018	1,354
2019	1,309
2020	1,141
2021	1,216
2022	1,272
2023	1,216
2024	1,139
2025	779
2026	365

Where

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 year(c."eventDate") = 1969 AND c."completionStatus" = 'Completed' 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 year(c.\"eventDate\") = 1969
    AND c.\"completionStatus\" = 'Completed'
  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 year(c."eventDate") = 1969
  AND c."completionStatus" = 'Completed'
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 SEA70D0151Accident · No injuriesClosedPiper PA-24 · Mulino, ORDec 31, 1969 · N6373P · Substantial damage NTSB OAK70O0002Accident · Serious injuriesClosedPilatus PC-6 · Saigon, VMDec 31, 1969 · N391R · Substantial damage NTSB OAK70D0206Accident · No injuriesClosedPiper PA-16 · Antioch, CADec 31, 1969 · N5333H · Substantial damage NTSB MKC70D0315Accident · No injuriesClosedCessna 310N · Monticello, IADec 31, 1969 · N4115Q · Substantial damage NTSB MKC70D0309Accident · No injuriesClosedPiper PA-23 · Grand Isle, NEDec 31, 1969 · N441RV · Substantial damage NTSB MIA70D0288Accident · No injuriesClosedCessna 182K · Titusville, FLDec 31, 1969 · N2879R · Substantial damage NTSB MIA70A0051Accident · 4 fatalClosedBeech V35A · Tampa, FLDec 31, 1969 · N8351N · Destroyed NTSB LAX70D0240Accident · No injuriesClosedCessna 310B · Phoenix, AZDec 31, 1969 · N5463A · Substantial damage NTSB LAX70D0232Accident · No injuriesClosedCessna 182 · Flagstaff, AZDec 31, 1969 · N71006 · Substantial damage NTSB IAD70A0036Accident · No injuriesClosedBeech D18S · Friendship Apt, MDDec 31, 1969 · N80385 · Substantial damage NTSB FTW70D0350Accident · No injuriesClosedCessna 150 · Richardson, TXDec 31, 1969 · N23244 · Substantial damage NTSB FTW70A0044Accident · 1 fatalClosedPiper PA-24 · Boynton, OKDec 31, 1969 · N6011P · Destroyed NTSB OAK70F0212Accident · 1 fatalClosedBell 47G3B1 · Hamiltn Afb, CADec 30, 1969 · N1320X · Substantial damage NTSB OAK70F0207Accident · Minor injuriesClosedCessna 182 · Honaunau, HIDec 30, 1969 · N1953X · Destroyed NTSB MIA70D0304Accident · No injuriesClosedCessna 310H · Lamar, SCDec 30, 1969 · N433R · Substantial damage NTSB MIA70D0298Accident · No injuriesClosedCessna 170B · Freeport, Burkina FasoDec 30, 1969 · N3280A NTSB DEN70D0155Accident · No injuriesClosedCessna 150 · Canjilon, NMDec 30, 1969 · N5703E · Substantial damage NTSB DEN70A0042Accident · 2 fatalClosedCessna 177 · Monticello, UTDec 30, 1969 · N2335Y · Destroyed NTSB CHI70F0389Accident · Minor injuriesClosedBeech B50 · Terre Haute, INDec 30, 1969 · N3678B · Substantial damage NTSB CHI70F0386Accident · Serious injuriesClosedPiper PA-28 · Pleasnt Hill, OHDec 30, 1969 · N95194 · Substantial damage NTSB CHI70D0390Accident · No injuriesClosedPiper PA-22 · Roselle, ILDec 30, 1969 · N5747Z · Substantial damage NTSB CHI70D0369Accident · No injuriesClosedCessna 150 · Orfordville, WIDec 30, 1969 · N6236R · Substantial damage NTSB ANC70A0051Accident · Minor injuriesClosedCessna 180 · Cordova, AKDec 30, 1969 · N8619X · Substantial damage NTSB SEA70D0141Accident · No injuriesClosedCessna 175 · Ryegate, MTDec 29, 1969 · N6670E · Substantial damage NTSB MKC70F0314Accident · Minor injuriesClosedCessna 177 · Newell, SDDec 29, 1969 · N3427T · Substantial damage NTSB MKC70A0037Accident · 2 fatalClosedPiper PA-30 · Vermillion, SDDec 29, 1969 · N7201Y · Destroyed NTSB MIA70F0283Accident · Minor injuriesClosedEnstrom F28A · Phenix City, ALDec 29, 1969 · N4880 · Substantial damage NTSB MIA70F0282Accident · No injuriesClosedPiper PA-12 · Crossville, TNDec 29, 1969 · N2301M · Substantial damage NTSB MIA70D0281Accident · No injuriesClosedCessna 150 · Defuniak Spgs, FLDec 29, 1969 · N7886F · Substantial damage NTSB LAX70D0227Accident · No injuriesClosedCessna 182L · Burbank, CADec 29, 1969 · N3181R · Substantial damage NTSB IAD70D0121Accident · No injuriesClosedCessna 172 · Monroe, NCDec 29, 1969 · N5775A · Substantial damage NTSB ANC70A0050Accident · Minor injuriesClosedStinson V-77 · Golovin, AKDec 29, 1969 · N50225 · Substantial damage NTSB OAK70D0195Accident · No injuriesClosedCessna 150 · Fresno, CADec 28, 1969 · N3703J · Substantial damage NTSB NYC70D0238Accident · No injuriesClosedCessna 150H · Zelienople, PADec 28, 1969 · N23183 · Substantial damage NTSB MKC70A0036Accident · 2 fatalClosedCessna 180 · Pierce, NEDec 28, 1969 · N9117C · Destroyed NTSB IAD70F0119Accident · No injuriesClosedMooney M20C · Charlotte, NCDec 28, 1969 · CF-PZN · Substantial damage NTSB IAD70D0123Accident · Serious injuriesClosedCessna 150 · Sanford, NCDec 28, 1969 · N7817Z · Substantial damage NTSB CHI70I0042Incident · No injuriesClosedDehavilland DH114 · Cleveland, OHDec 28, 1969 · N506FW · Minor damage NTSB CHI70D0398Accident · No injuriesClosedCessna 150 · Painesville, OHDec 28, 1969 · N3875J · Substantial damage NTSB ANC70D0087Accident · No injuriesClosedPiper PA-18 · Glennallen, AKDec 28, 1969 · N2992Z · Substantial damage NTSB OAK70A0034Accident · 2 fatalClosedCessna 177 · Lake Tahoe, CADec 27, 1969 · N29500 · Destroyed NTSB MKC70F0316Accident · Minor injuriesClosedCessna 182H · Kansas City, KSDec 27, 1969 · N1803X · Substantial damage NTSB MKC70F0313Accident · No injuriesClosedBeech A23A · Lake Elmo, MNDec 27, 1969 · N7414T · Substantial damage NTSB MIA70F0277Accident · No injuriesClosedPiper PA-28 · Byrdstown, TNDec 27, 1969 · N5022W · Substantial damage NTSB MIA70F0260Accident · No injuriesClosedBeech A23 · Opa Locka, FLDec 27, 1969 · N3647Q · Substantial damage NTSB MIA70D0301Accident · No injuriesClosedPiper PA-23 · Cedartown, GADec 27, 1969 · N3079P · Substantial damage NTSB MIA70D0276Accident · No injuriesClosedCessna 310B · Sanibel, FLDec 27, 1969 · N664B · Substantial damage NTSB MIA70D0264Accident · No injuriesClosedCessna 150 · St Elmo, ALDec 27, 1969 · N3465J · Destroyed NTSB LAX70F0238Accident · Minor injuriesClosedPiper PA-28 · Rialto, CADec 27, 1969 · N9783W · Substantial damage NTSB IAD70D0130Accident · No injuriesClosedCessna 195A · Lynchburg, VADec 27, 1969 · N4360N · Substantial damage