Skip to content

NTSB investigations · 1,496

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2071826') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2071826')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2071826')
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 MKC76DER78Accident · No injuriesClosedCessna 150L · Carlton, MNJul 10, 1976 · N1601Q · Substantial damage NTSB MIA76FKQ37Accident · No injuriesClosedCessna A188B · Hollandale, MSJul 9, 1976 · N6694G · Substantial damage NTSB MIA76FLG37Accident · No injuriesClosedCessna 150 · Rock Hill, SCJul 8, 1976 · N18019 · Substantial damage NTSB MKC76AK065Accident · 1 fatalClosedCessna 150 · Thief Rv Falls, MNJul 7, 1976 · N1728Q · Destroyed NTSB IAD76DLQ25Accident · No injuriesClosedCessna 150 · Hodgenville, KYJul 3, 1976 · N10660 · Substantial damage NTSB FTW76DRG73Accident · No injuriesClosedCessna 150 · Port Mansfield, TXJul 3, 1976 · N1690Q · Substantial damage NTSB DEN76FTC38Accident · Minor injuriesClosedCessna 150L · Rock Springs, WYJul 3, 1976 · N6710G · Substantial damage NTSB SEA76AS057Accident · 1 fatalClosedCessna 150L · Clatskanie, ORJun 28, 1976 · N19310 · Destroyed NTSB MKC76DCG81Accident · No injuriesClosedCessna 150 · Springfield, MOJun 26, 1976 · N10107 · Substantial damage NTSB FTW76FPD48Accident · No injuriesClosedCessna 150 · Pottsville, TXJun 26, 1976 · N18021 · Substantial damage NTSB SEA76FYC60Accident · No injuriesClosedCessna 150L · Oregon City, ORJun 25, 1976 · N10297 · Substantial damage NTSB MIA76FKG77Accident · Minor injuriesClosedCessna 150L · Jessup, GAJun 24, 1976 · N1560Q · Destroyed NTSB ANC76DAH21Accident · No injuriesClosedCessna 150 · Anchorage, AKJun 15, 1976 · N10917 · Substantial damage NTSB OAK76DVM44Accident · No injuriesClosedCessna 150 · Palo Alto, CAJun 9, 1976 · N10615 · Substantial damage NTSB MKC76DCQ60Accident · No injuriesClosedCessna 150 · Colby, KSJun 9, 1976 · N16025 · Substantial damage NTSB CHI76FEA43Accident · No injuriesClosedCessna 150 · Charlestown, INJun 9, 1976 · N18171 · Substantial damage NTSB NYC76DFJ23Accident · No injuriesClosedCessna 150 · Elmira, NYJun 3, 1976 · N18717 · 2 aircraft · Substantial damage NTSB LAX76FUG54Accident · Serious injuriesClosedCessna 150 · Yucaipa, CAMay 29, 1976 · N10463 · Substantial damage NTSB FTW76DQG71Accident · No injuriesClosedCessna 150 · Amarillo, TXMay 29, 1976 · N6638G · Substantial damage NTSB NYC76DFA38Accident · No injuriesClosedCessna 150 · Kingston, NYMay 28, 1976 · N1603Q · Substantial damage NTSB OAK76FVA66Accident · No injuriesClosedCessna 150L · Fresno, CAMay 22, 1976 · N1421Q · Substantial damage NTSB FTW76DRD49Accident · No injuriesClosedCessna 150 · Lake Charles, LAMay 21, 1976 · N11265 · Substantial damage NTSB MIA76DKA06Accident · No injuriesClosedCessna 150L · Moca, PRMay 16, 1976 · N1707Q · Substantial damage NTSB MIA76DLD55Accident · Minor injuriesClosedCessna 150 · Plymouth, FLMay 8, 1976 · N1202Q · Destroyed NTSB SEA76DTI25Accident · No injuriesClosedCessna 150 · Three Forks, MTMay 5, 1976 · N18119 · Substantial damage NTSB MIA76FKT74Accident · No injuriesClosedCessna 150 · Homestead, FLMay 2, 1976 · N8996M · Substantial damage NTSB CHI76FEA30Accident · No injuriesClosedCessna 150L · Bloomington, INApr 27, 1976 · N19318 · Substantial damage NTSB MIA76DKT69Accident · No injuriesClosedCessna 150 · Pembrook Pines, FLApr 25, 1976 · N11294 · Substantial damage NTSB NYC76DFA33Accident · No injuriesClosedCessna 150 · Scotia, NYApr 18, 1976 · N11438 · Substantial damage NTSB MIA76DKJ58Accident · No injuriesClosedCessna 150L · Jasper, ALApr 18, 1976 · N1634Q · Substantial damage NTSB CHI76DEV30Accident · No injuriesClosedCessna 150L · Bloomington, ILApr 9, 1976 · N7522G · Substantial damage NTSB FTW76DRD37Accident · No injuriesClosedCessna 150 · Hathaway, LAApr 2, 1976 · N6616G · Substantial damage NTSB OAK76FVA52Accident · No injuriesClosedCessna 150L · Fresno, CAApr 1, 1976 · N6800G · Substantial damage NTSB OAK76DVG62Accident · No injuriesClosedCessna 150 · Marysville, CAMar 27, 1976 · N10954 · Substantial damage NTSB OAK76DVG57Accident · No injuriesClosedCessna 150 · Napa, CAMar 21, 1976 · N19578 · Substantial damage NTSB FTW76DPA20Accident · No injuriesClosedCessna 150 · Sherman, TXMar 21, 1976 · N18533 · Substantial damage NTSB NYC76DFA29Accident · No injuriesClosedCessna 150 · Kingston, NYMar 20, 1976 · N19490 · Substantial damage NTSB MKC76DCG57Accident · No injuriesClosedCessna 150L · Lawrence, KSMar 16, 1976 · N6095J · Substantial damage NTSB OAK76DVG51Accident · No injuriesClosedCessna 150 · Redding, CAMar 9, 1976 · N10663 · Substantial damage NTSB NYC76AN087Accident · 2 fatalClosedCessna 150L · Plymouth, MAMar 5, 1976 · N19398 · Substantial damage NTSB LAX76DUM20Accident · No injuriesClosedCessna 150 · Agua Caliente, CAFeb 28, 1976 · N19346 · Substantial damage NTSB FTW76DRA24Accident · No injuriesClosedCessna 150 · Addicks, TXFeb 25, 1976 · N21978 · Destroyed NTSB DEN76DTC25Accident · No injuriesClosedCessna 150L · Jackson, WYFeb 24, 1976 · N11261 · Substantial damage NTSB NYC76AN082Accident · 1 fatalClosedCessna 150 · Frackville, PAFeb 22, 1976 · N19165 · Destroyed NTSB SEA76FYC31Accident · Serious injuriesClosedCessna 150L · Sandy, ORFeb 18, 1976 · N19426 · Substantial damage NTSB CHI76FEC26Accident · No injuriesClosedCessna 150L · Westland, MIFeb 12, 1976 · N1528Q · Substantial damage NTSB MIA76AM060Accident · Minor injuriesClosedCessna 150L · Walls, MSFeb 8, 1976 · N11626 · 2 aircraft · Substantial damage NTSB MKC76DCD26Accident · No injuriesClosedCessna 150L · New Sharon, IAFeb 7, 1976 · N16132 · Substantial damage NTSB CHI76FET26Accident · No injuriesClosedCessna 150L · Goshen, INFeb 7, 1976 · N19209 · Substantial damage NTSB CHI76FEK10Accident · No injuriesClosedCessna 150 · Lima, OHFeb 7, 1976 · N19079 · Substantial damage

Back to Cessna 150L