Skip to content

NTSB investigations, 1969

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

NTSB investigations, 1969 per year, 1962–2026: 180,581 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,514
1984	3,405
1985	3,055
1986	2,831
1987	2,774
1988	2,685
1989	2,502
1990	2,479
1991	2,419
1992	2,328
1993	2,283
1994	2,229
1995	2,281
1996	2,150
1997	2,121
1998	2,195
1999	2,175
2000	2,183
2001	2,031
2002	2,000
2003	2,062
2004	1,930
2005	2,001
2006	1,826
2007	1,984
2008	1,882
2009	1,783
2010	1,786
2011	1,848
2012	1,834
2013	1,561
2014	1,534
2015	1,581
2016	1,662
2017	1,635
2018	1,687
2019	1,626
2020	1,396
2021	1,645
2022	1,700
2023	1,678
2024	1,693
2025	1,655
2026	1,342

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 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
  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
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