Final NTSB investigations: Boeing 737-247

7 cases on aircraft the registry lists as Boeing 737-247. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19692026

Final NTSB investigations: Boeing 737-247 per year, 1969–2026: 7 cases
1969	1
1970	1
1973	1
1975	1
1976	1
1978	1
2005	1

Where

Open the map

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 c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('138448D')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('138448D'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('138448D'))
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 NYC05LA043Accident · No injuriesLimited investigationFinal reportBoeing 737-247 · Covington, KYThe catering truck driver's failure to maintain clearance of the parked airplane by his inadvertent depressing the accelerator. A factor in this accident was the catering truck driver's diverted attention.Jan 17, 2005 · N373DL · Substantial damage NTSB DEN78FA045Accident · Serious injuriesClosedBoeing 737 · Cheyenne, WYMay 30, 1978 · N4518W · Minor damage NTSB LAX77IA003Incident · Serious injuriesClosedBoeing 737 · Salt Lake City, UTOct 5, 1976 · N4523W · No damage NTSB DEN75AD050Accident · Serious injuriesClosedBoeing 737 · Casper, WYMar 31, 1975 · N4527W · Substantial damage NTSB LAX73IL063Incident · Minor injuriesClosedBoeing 737 · Las Vegas, NVJun 8, 1973 · N4519W · Minor damage NTSB LAX70IL042Incident · No injuriesClosedBoeing 737 · Long Beach, CAJan 15, 1970 · N4518W · No damage NTSB LAX70I0025Incident · No injuriesClosedBoeing 737 · Phoenix, AZOct 30, 1969 · N4528W · Minor damage