Final NTSB investigations: Boeing N2S-3
6 cases on aircraft the registry lists as Boeing N2S-3. 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.
Cases per year
| 1967 | 1 |
|---|---|
| 1976 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 2007 | 1 |
| 2020 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('1380146'))
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 ('1380146'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CEN20CA303Accident · No injuriesClass 4 · Data collectionFinal reportStearman N2S 3 · Jacksonville, ARThe pilot's failure to adequately monitor his fuel quantity during flight, which resulted in fuel exhaustion and a total loss of engine power.NTSB CHI07CA194Accident · Minor injuriesData collectionFinal reportBoeing N2S-3 · Trenton, MOThe pilot's failure to maintain sufficient altitude/clearance above the water while maneuvering. A factor in the accident was the low altitude maneuver attempted by the pilot.NTSB LAX91FA094Accident · 2 fatalField investigationFinal reportBoeing N2S-3 · Sonoma, CAThe pilot-in-command/cfi's performance of a low altitude aerobatic maneuver from which he failed to recover. Factors which contributed to the accident related to the pic's improper inflight decision, poor judgment, and his psychological condition.NTSB MKC89LA023Accident · No injuriesLimited investigationFinal reportStearman B75N1 · Benton, ARThe flt was uneventful until the landing at the saline county arpt, Benton, ark. The PIC stated he applied too much brake and applied it prematurely during the landing roll and the acft nosed over to the inverted posn. The resultant impact crushed the…NTSB FTW76DQG67Accident · Serious injuriesClosedBoeing B75N1 · Childress, TXNTSB FTW68A0031Accident · 1 fatalClosedBoeing N2S-3 · Lake Charles, LA