NTSB investigations: Mong Sport MS-2

5 cases on aircraft the registry lists as Mong Sport MS-2. 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

19672026

NTSB investigations: Mong Sport MS-2 per year, 1967–2026: 5 cases
1967	1
1971	1
1972	1
1979	1
1993	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('57901H2', '57901J3', '57901NS', '57901JC', '57901KU', '57901LK')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('57901H2', '57901J3', '57901NS', '57901JC', '57901KU', '57901LK'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('57901H2', '57901J3', '57901NS', '57901JC', '57901KU', '57901LK'))
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 CHI93FA274Accident · 2 fatalField investigationFinal reportCessna A150K · Goshen, INFailure of both pilots to see and avoid each other. A factor in the accident was the position of the sun which resulted in sun glare for the pilot of the mong sport.Jul 25, 1993 · N8382M · 2 aircraft · Destroyed NTSB MKC79FA052Accident · 1 fatalClosedMong Sport MS-2 · Sidney, NESep 6, 1979 · N563A · Destroyed NTSB CHI72FLQ32Accident · Serious injuriesClosedMong Sport MS-2 · Elizabethtown, KYMar 25, 1972 · N2376 · Substantial damage NTSB CHI72FEM20Accident · 1 fatalClosedMong Sport MS-2 · Negaunee, MISep 6, 1971 · N38M · Destroyed NTSB CHI68D0044Accident · No injuriesClosedMong Sport MS-2 · Phillipsburg, OHJun 25, 1967 · N570A · Substantial damage