Skip to content

NTSB investigations · 26

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 ('5450702') 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 ('5450702')
  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 ('5450702')
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 DEN86FA175Accident · 3 fatalField investigationFinal reportMartin 404 · Buffalo, WYN40443 was contracted by the Wyoming dept of ag to spray grasshoppers. Investigation revealed the plt held a pvt certificate with asmel ratings. His medical certificate was denied because he failed to provide information concerning high blood pressure and…Jun 27, 1986 · N40443 · Destroyed NTSB LAX82FA174Accident · No injuriesField investigationFinal reportMartin 404 · Madera, CAAfter takeoff the aircraft was observed to trail a brown substance. About 3 miles from the airport the right engine oil pressure dropped. The pilot decided to return to the airport. When he thought the runway was attainable he lowered the flaps; however, a…May 15, 1982 · N40445 · Destroyed NTSB DCA80AA021Accident · FatalClosedMartin 404 · Tusayan, AZNov 16, 1979 · N40438 · Destroyed NTSB FTW79FQG45Accident · Serious injuriesClosedMartin 404 · Miami, TXJun 29, 1979 · N40408 · Destroyed NTSB UNK79X0102Accident · No injuriesClosedMartin 404 · Gulf Of Venezuela, VenezuelaNov 18, 1978 · N13415 · Destroyed NTSB MIA75IM088Incident · No injuriesClosedMartin 404 · Key West, FLJun 16, 1975 · N40425 · Minor damage NTSB MIA73AM023Accident · No injuriesClosedMartin 404 · Ft.Lauderdale, FLAug 25, 1972 · N469M · Substantial damage NTSB MIA72IM084Incident · No injuriesClosedMartin 404 · Columbus, MSFeb 21, 1972 · N259S · Minor damage NTSB MIA71AM045Accident · No injuriesClosedMartin 404 · Atlanta, GADec 10, 1970 · N143S · Minor damage NTSB DCA71AZ004Accident · 30 fatalClosedMartin 404 · Silver Plume, COOct 2, 1970 · N464M · Destroyed NTSB MIA70AM093Accident · 1 fatalClosedMartin 404 · Atlanta, GAMay 30, 1970 · N40412 · Destroyed NTSB IAD70II043Incident · No injuriesClosedMartin 404 · Rocky Mount, NCFeb 10, 1970 · N40402 · Minor damage NTSB DIA67A0019Accident · Serious injuriesClosedMartin M-404 · Wilmington, NCMay 19, 1967 · N40414 · No damage NTSB CHI67A0084Accident · No injuriesClosedMartin 404 · Cleveland, OHJan 7, 1967 · N478A · Substantial damage NTSB MIA67A0058Accident · 3 fatalClosedMartin M-404 · New Bern, NCNov 20, 1966 · N40406 · Destroyed NTSB NYC67A0007Accident · Serious injuriesClosedMartin M-404 · Roanoke, VAJul 9, 1966 · N40446 · Substantial damage NTSB OAK66A0012Accident · No injuriesClosedMartin M-404 · San Jose, CASep 19, 1965 · N444A · No damage NTSB MIA66I0005Incident · No injuriesClosedMartin M-404 · Winston Salem, NCJul 9, 1965 · N40448 · Minor damage NTSB NYC65 0096Accident · No injuriesClosedMartin M-404 · Weyers Cave, VAJan 21, 1965 · N40448 · Substantial damage NTSB NYC65I0094Incident · No injuriesClosedMartin M-404 · Roanoke, VAJan 9, 1965 · N40415 · Minor damage NTSB UNK64X0737Accident · No injuriesClosedMartin M-404 · Binghamton, NYFeb 29, 1964 · N472M · Substantial damage NTSB DCA64A0008Accident · 7 fatalClosedMartin 404 · Rochester, NYJul 2, 1963 · N449A · Destroyed NTSB FTW63A0173Accident · No injuriesClosedMartin 404 · Baton Rouge, LAJun 17, 1963 · N145S · Substantial damage NTSB MIA62A0062Accident · Minor injuriesClosedMartin 404 · Wilmington, NCAug 22, 1962 · N40401 · Destroyed NTSB MIA62A0055Accident · No injuriesClosedMartin 404 · Rocky Mount, NCAug 6, 1962 · N40415 · Substantial damage NTSB LAX62A0038Accident · No injuriesClosedMartin 404 · Lompoc, CAApr 17, 1962 · N40436 · Substantial damage

Back to Martin 404